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?

Thanks!

Options: ReplyQuote


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


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.