MySQL Forums
Forum List  »  Newbie

Optimize REGEXP
Posted by: Hor Kol
Date: August 05, 2022 05:58AM

I have a table with MEDIUMTEXT field.
Table has 2500 records.
This query takes about 26 seconds to finish:

SELECT myText FROM myTable
WHERE myText REGEXP "\\w*heart\\w*";

Every myText field has text which length is about 50.000 characters (about 6 pages of text).

How to optimize this query?

Options: ReplyQuote

Written By
Optimize REGEXP
August 05, 2022 05:58AM
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.