From: Date: September 14 2004 10:43pm
Subject: Re: Fulltext doesn't seem to find certain text
List-Archive: http://lists.mysql.com/mysql/172606
Message-Id: <414757D6.2070504@frontiernet.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

mos wrote:
> 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
> 

What variable setting is changed in the my.cnf, and is this under the mysqld 
group ??

What is the proceedure to rebuild the FT indexes and the changes are made ??

TIA

-- 
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://thunder-rain.com/
Tel: 1.712.395.0670
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=