MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Optimize REGEXP
Hor Kol
August 05, 2022 05:58AM
Re: Optimize REGEXP
Peter Brawley
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.