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
231
December 04, 2021 12:25PM
120
December 04, 2021 08:07PM
Re: MATCH Keywords with Spaces AGAINST Large Text
132
December 05, 2021 11:56AM
142
December 05, 2021 12:08PM
112
December 05, 2021 03:22PM
118
December 05, 2021 07:33PM
125
December 05, 2021 07:45PM
190
December 05, 2021 08:32PM
103
December 06, 2021 12:18PM
94
December 22, 2021 10:59AM
79
December 22, 2021 12:30PM
177
December 06, 2021 12:30PM