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,
See http://dev.mysql.com/doc/mysql/en/Fulltext_Fine-tuning.html. Also see Attila Nagy's recommendation on using Drop Index/Build Index rather than Repair Table.
Mike
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
