MySQL Forums
Forum List  »  Full-Text Search

Re: MATCH Keywords with Spaces AGAINST Large Text
Posted by: David Allen
Date: December 05, 2021 11:56AM

Hey Peter - thanks for the response!

I believe you meant:
var_text LIKE CONCAT('%',sm.sit_name,'%')

Of course this doesn't work because it would pull matches that were part of words, so we would get a match of ".net" for ".netercize".

That's why I use REGEXP with the break around the word; it seems to work well, but I could expand on it.

Ultimately what it comes down to is speed. I can enhance REGEXP to scan around the words for spaces, dashes, quotes, etc. to get full word match.

But none of that is nearly as fast as MATCH AGAINST.

As far as I'm aware, REGEXP and LIKE don't use the FULLTEXT index, correct? Is there any way to get MATCH AGAINST to work how I need it in this scenario? If not, what's the best indexing process I can use for REGEXP and/or LIKE matching?


Options: ReplyQuote

Written By
Re: MATCH Keywords with Spaces AGAINST Large Text
December 05, 2021 11:56AM

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.