MySQL Forums
Forum List  »  Full-Text Search

Re: Problem with words contains '-' character
Posted by: Faury Rodriguez
Date: March 12, 2008 06:20PM

Hi by default the - is not a true word character so it is used as a term delimiter, i.e. in the index the term LD-3W is two words LD and 3W. Also by default the minimum indexable word length is 4 characters so they don't even get into the index.

I would replace the hyphen with an underscore which is a true word character. Then searching on LD_3W should work. Or removing the hyphens all together, then searching on LD3W should work.

Options: ReplyQuote

Written By
Re: Problem with words contains '-' character
March 12, 2008 06:20PM

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.