Re: New is not counted as a word
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
Subject
Views
Written By
Posted
3767
March 17, 2010 12:22PM
Re: New is not counted as a word
2299
March 21, 2010 06:09PM
2266
March 21, 2010 10:28PM
2006
March 22, 2010 08:35AM
1980
March 22, 2010 08:35AM
2920
March 23, 2010 12:23PM
2234
March 24, 2010 02:11AM
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.