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
584
December 04, 2021 12:25PM
234
December 04, 2021 08:07PM
Re: MATCH Keywords with Spaces AGAINST Large Text
275
December 05, 2021 11:56AM
273
December 05, 2021 12:08PM
243
December 05, 2021 03:22PM
246
December 05, 2021 07:33PM
266
December 05, 2021 07:45PM
295
December 05, 2021 08:32PM
267
December 06, 2021 12:18PM
231
December 22, 2021 10:59AM
178
December 22, 2021 12:30PM
316
December 06, 2021 12:30PM