safe_mysqld -O ft_min_word_len=2
You then have to rebuild the indexes
REPAIR TABLE tbl_name QUICK;
--Joe
On Thursday, May 29, 2003, at 08:47 PM, Daniel Rossi wrote:
It's not a bug, by deafult variable ft_min_word_len=4, but you search word 'DB' has length 2.
If you want to search both exact matches use + operator in BOOLEAN MODE or phrase search:
http://www.mysql.com/doc/en/Fulltext_Search.html
ok well i'm soughting that out but how about the default boolean value ?
ft_boolean_default='AND' if i set it to this , how can i explicitly go from AND to OR ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- Joe Stump - [EMAIL PROTECTED] http://www.jerum.com "Software never has bugs. It just develops random features."
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]