MySQL Forums
Forum List  »  Full-Text Search

Re: New is not counted as a word
Posted by: Jonathon Coombes
Date: March 21, 2010 06:09PM

Hi,

There is an option which determines the minimum word length used for full text searches. This is ft_min_word_len and it defaults to a value of 4. Since 'new' is only 3 letters, it is not found in the search.

If you want to match 'new', you could try reducing the value of ft_min_word_len and then try again. Note however, that reducing this value does add some overhead to the searches as it indexes more words.

Be aware that there are some other limitations on using fulltext as well:

http://dev.mysql.com/doc/refman/5.1/en/fulltext-restrictions.html

Options: ReplyQuote


Subject
Views
Written By
Posted
3831
March 17, 2010 12:22PM
Re: New is not counted as a word
2350
March 21, 2010 06:09PM


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.