Page 1 of 1

Something weird

Posted: Thu Feb 01, 2007 4:00 pm
by user___
I have faced something weird in fulltext search. I was testing my application and typed a sample tile:"Php and OOP". When I tried to search for "Php" I had no result although it was in boolean mode. After that I tried with the "OOP" but I got the same output. Does anyone know how to cope with this? I got to the conclusion that MySQL searches only for corect words but then I tried with my name, which is very unusual and I am sure there is not any dictionary that has it in its database, and I got a result.

Posted: Thu Feb 01, 2007 4:06 pm
by mikeq
did a quick search on google, reading a post on someones blog came up with this
ft_min_word_len *really* should be lowered to 3 by default.
and

http://dev.mysql.com/doc/refman/5.0/en/ ... uning.html

amazing what you can find when you take the trouble to have look