MySQL Forums
Forum List  »  Full-Text Search

Re: Problem with words like 'S&S' or 'W&W'
Posted by: Neo G.
Date: February 23, 2009 09:15AM

Hi Tom,

The default configuration for FULLTEXT search only searches words that are 4 characters and more and there are also stop words. In order to bypass this, you will need to edit the mysql configuration file and add this under the [mysqld] section:

[mysqld]
ft_min_word_len=1
ft_stopword_file=''

Afterwards, make sure you do repair table TABLENAME quick to recreate the fulltext indexes to include shorter words.

Good luck.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Problem with words like 'S&S' or 'W&W'
2895
February 23, 2009 09:15AM


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.