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


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:

Options: ReplyQuote

Written By
March 17, 2010 12:22PM
Re: New is not counted as a word
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.