Something weird

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
user___
Forum Contributor
Posts: 297
Joined: Tue Dec 05, 2006 3:05 pm

Something weird

Post 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.
User avatar
mikeq
Forum Regular
Posts: 512
Joined: Fri May 03, 2002 3:33 am
Location: Edinburgh, Scotland

Post 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
Post Reply