Re: MATCH Keywords with Spaces AGAINST Large Text
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!
Subject
Views
Written By
Posted
500
December 04, 2021 12:25PM
211
December 04, 2021 08:07PM
Re: MATCH Keywords with Spaces AGAINST Large Text
228
December 05, 2021 11:56AM
234
December 05, 2021 12:08PM
203
December 05, 2021 03:22PM
207
December 05, 2021 07:33PM
220
December 05, 2021 07:45PM
266
December 05, 2021 08:32PM
210
December 06, 2021 12:18PM
181
December 22, 2021 10:59AM
155
December 22, 2021 12:30PM
276
December 06, 2021 12:30PM