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

[mysqld]
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: http://tech.lds.org/forum/showthread.php?t=520

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


Subject
Views
Written By
Posted
4966
September 17, 2008 12:01PM
Re: Problem with searching short words
3364
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.