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
3889
March 17, 2010 12:22PM
Re: New is not counted as a word
2387
March 21, 2010 06:09PM
2328
March 21, 2010 10:28PM
2107
March 22, 2010 08:35AM
2039
March 22, 2010 08:35AM
2983
March 23, 2010 12:23PM
2296
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.