Re: MATCH Keywords with Spaces AGAINST Large Text

[David Allen]

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!