Re: Odd fulltext matching

2002-01-18 Thread Sergei Golubchik
Hi! On Jan 18, Jason Morehouse wrote: > Hello, > > Using a fulltext search on a products database I'm running into some > rather strange results. > > I'm using MySQL 3.23.32 on a Redhat 7.1 Linux box. > > Thanks in advance for any help, > > Cheers, > -Jason It looks like a bug to me (or two

Odd fulltext matching

2002-01-17 Thread Jason Morehouse
Hello, Using a fulltext search on a products database I'm running into some rather strange results. I'm trying to get a list of matches sorted by relevance. Here is the query: select products_name,MATCH (products_name,products_name,products_description,item) AGAINST ('necker knife') as score f