MySQL Forums
Forum List  »  Full-Text Search

Advanced Search
New Topic

Re: can't get fulltext to work
Posted by: Jay Pipes
Date: July 01, 2005 09:49AM

The reason you're not getting some results is because FULLTEXT, by default, does not match on words less than 4 characters in length. In order to get FULLTEXT indexes to match shorter words, you must adjust the ft_min_word_len configuration variable. You can read more about tuning this here:

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

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
can't get fulltext to work
3509
Matthew Boehm
July 01, 2005 08:34AM
Re: can't get fulltext to work
2466
Jay Pipes
July 01, 2005 09:49AM


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.