RE: Fulltext doesn't seem to find certain text
That might be a word defined in the stopword file, excluding full text lookup on. Stop words are words like The As In If And so on. DVP Dathan Vance Pattishall http://www.friendster.com -Original Message- From: joe mcguckin [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 10:55 AM To: [EMAIL PROTECTED] Subject: Fulltext doesn't seem to find certain text If I perform a fulltext search for 'foo', it won't match text like 'foo, inc'. Why? Mysql 3.23.52 -- Joe McGuckin ViaNet Communications 994 San Antonio Road Palo Alto, CA 94303 Phone: 650-213-1302 Cell: 650-207-0372 Fax: 650-969-2124 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fulltext doesn't seem to find certain text
A guess, its looking for that string. Maybe should be looking something like it example select * from table where var like '%foo%' -Blake joe mcguckin wrote: If I perform a fulltext search for 'foo', it won't match text like 'foo, inc'. Why? Mysql 3.23.52 -- +-+-++ | Blake Schroeder | Owner/Developer |lhwd.net| +--(http://www.lhwd.net)+--/ \--+ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fulltext doesn't seem to find certain text
On Tue, 14 Sep 2004, joe mcguckin wrote: If I perform a fulltext search for 'foo', it won't match text like 'foo, inc'. In addition to the other suggestions, make sure our ft_min_word_len isn't more than 2, because it won't index words shorter than that many characters. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fulltext doesn't seem to find certain 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fulltext doesn't seem to find certain text
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 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fulltext doesn't seem to find certain text
At 03:43 PM 9/14/2004, Mike Blezien wrote: 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]