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


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


Sorry, only registered users may post in this forum.

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.