MySQL Forums
Forum List  »  Full-Text Search

Re: Searching a keyword containing a double quote
Posted by: Rick James
Date: April 10, 2011 11:49AM

FULLTEXT is aimed at English text. It stumbles for other things.

Plan A: Sanitize (Acer 24") -> (acer24) and put that in another column or in a table of 'tags'.

Plan B: See if Lucene or Sphinx can do a better job.

Plan C: Think of some other way to deal with product names.

What are you going to do with 2-char words? Words in the stop list? Etc.

Options: ReplyQuote

Written By
Re: Searching a keyword containing a double quote
April 10, 2011 11:49AM

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.