MySQL Forums
Forum List  »  Newbie

Re: Optimize REGEXP
Posted by: Peter Brawley
Date: August 05, 2022 07:50AM

RegExp() forces MySQL to read every referenced field in every row. That can be slow, and indexing cannot speed it up.

For your query, ...WHERE myText LIKE "%heart%"... would be less precise and much less slow.

Options: ReplyQuote

Written By
August 05, 2022 05:58AM
Re: Optimize REGEXP
August 05, 2022 07:50AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.