MySQL Forums
Forum List  »  Full-Text Search

Re: Problem with searching short words
Posted by: Abhishek Kumar
Date: March 21, 2009 05:46AM

MySQL will not search for words less than 4 characters (like egg, car, bat, ok, yes, no, etc), if you are using full text search. This happens because of a default setting.

There is a configuration file called my.cnf. Make setting here

fit_min_word_len = 3

then it will search for words with 3 letters also. After making this change, restart your Apache server or IIS server, maybe also the MySQL server.

Read more:

But the problem with me is that I have installed MySQL by XAMPP package and the C:\xampp\mysql directory does not contain the my.cnf file. Seems that if you install it without XAMPP then it must be there.

Could someone tell me why I dont have my.cnf file on my installation??

Edited 1 time(s). Last edit at 03/21/2009 05:50AM by Abhishek Kumar.

Options: ReplyQuote

Written By
September 17, 2008 12:01PM
Re: Problem with searching short words
March 21, 2009 05:46AM

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.