MySQL Forums
Forum List  »  Full-Text Search

Re: Full text search is not working on some values
Posted by: Ike Walker
Date: August 23, 2007 08:12AM

Certain common words ("stopwords") are not indexed by default, so you won't get hits on those words.

Here is the default stopword list:

http://dev.mysql.com/doc/refman/5.0/en/fulltext-stopwords.html

If you want to override the default stopword list, you can create your own list and set it using the ft_stopword_file variable in your config file. More details on ft_stopword_file:

http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html

Also, words under a certain length are not indexed. Runs this at the mysql prompt to find out your setting:

show variables like 'ft_min_word_len';

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Full text search is not working on some values
4927
August 23, 2007 08:12AM


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.