Knowledgebase: General Q&A
When I use different keywords for keywords search, some of them work, some not. Keywords having length 3 characters or less produce no results. Can this search behaviour be changed ?
Posted by - NA - on 18 May 2005 11:56 AM
The MySQL full-text search capability has some user-tunable parameters.

For example, MySQL doesn't index small words (length 3 or less) by default.

The minimum word length to be indexed is controlled by a server
variable (ft_min_word_len), i. e. this setting affects full text search indexes of all databases on this server.

Please refer to MySQL documentation for more information :
http://dev.mysql.com/doc/mysql/en/fulltext-fine-tuning.html

Comments (0)
Help Desk Software by Kayako Fusion