MySQL Forums
Forum List  »  Full-Text Search

Re: Regarding FTS and Like queries
Posted by: Rick James
Date: January 22, 2016 06:38PM

"CutterCG40EYT" and "Cutter CG40EYT" are two different situations. FT cannot treat them as equal.

Plan A: You 'cleanse' the input and store one or the other, not both.

Plan B: You test for both on the output side.

Either way, product names/numbers/etc are a big mess to work with.

Options: ReplyQuote

Written By
January 09, 2016 04:23AM
January 10, 2016 05:36PM
Re: Regarding FTS and Like queries
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.