MySQL Forums
Forum List  »  Full-Text Search

Re: Regarding FTS and Like queries
Posted by: Rick James
Date: January 10, 2016 05:36PM

For 44 million rows, FT will be much faster than LIKE. And do it with

where match(`value`) against ('+Hitachi +Brush +Cutter' IN BOOLEAN MODE)

Suggest you remove any "words" shorter than 3 letters and any "stop" words.

If you need to check for "Hitachi Brush Cutter" but not "Hitachi Cutter Brush", then I suggest

where match(`value`) against ('+Hitachi +Brush +Cutter' IN BOOLEAN MODE)
AND value LIKE '%Hitachi Brush Cutter%'

This is because the FT search will be fast and result in a small number of rows, which will then tediously be searched by LIKE. Net result: still very fast.

Options: ReplyQuote


Subject
Views
Written By
Posted
2694
January 09, 2016 04:23AM
Re: Regarding FTS and Like queries
1072
January 10, 2016 05:36PM
1020
January 22, 2016 06:38PM


Sorry, you can't reply to this topic. It has been closed.

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.