List:General Discussion« Previous MessageNext Message »
From:mos Date:September 14 2004 8:26pm
Subject:Re: Fulltext doesn't seem to find certain text
View as plain text  
At 01:54 PM 9/14/2004, you wrote:
>If I perform a fulltext search for 'foo', it won't match text like
>'foo, inc'.
>
>Why?
>
>Mysql 3.23.52

Joe,
         By default MySQL has a 4 letter minimum for fulltext searches; 
words must be at least 4 letters in length otherwise they won't get added. 
Since you are using MySQL 3.23, you will need to recompile the binaries. 
With MySQL 4.x, you can simply change a variable in the configuration file 
and rebuild the fulltext indexes.

Mike 

Thread
Fulltext doesn't seem to find certain textjoe mcguckin14 Sep
  • RE: Fulltext doesn't seem to find certain textDathan Vance Pattishall14 Sep
  • Re: Fulltext doesn't seem to find certain textBlake Schroeder14 Sep
  • Re: Fulltext doesn't seem to find certain textTobias Asplund14 Sep
  • Re: Fulltext doesn't seem to find certain textmos14 Sep
  • Re: Fulltext doesn't seem to find certain textMike Blezien14 Sep
    • Re: Fulltext doesn't seem to find certain textmos14 Sep