Re: Fulltext doesn't seem to find certain text

2004-09-14 Thread mos
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

Re: Fulltext doesn't seem to find certain text

2004-09-14 Thread Mike Blezien
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. Si

Re: Fulltext doesn't seem to find certain text

2004-09-14 Thread mos
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

Re: Fulltext doesn't seem to find certain text

2004-09-14 Thread Tobias Asplund
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 Ma

Re: Fulltext doesn't seem to find certain text

2004-09-14 Thread Blake Schroeder
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 -- +-+--

RE: Fulltext doesn't seem to find certain text

2004-09-14 Thread Dathan Vance Pattishall
: 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 > >

Fulltext doesn't seem to find certain text

2004-09-14 Thread joe mcguckin
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 archiv