Re: Fulltext search not returning matches..

[Brent Baisley]

You didn't miss a step, everything is working as it should be. Meaning, 
MySQL will classify your search results as "irrelevant" if it matches 
more than half of the records. If you only have 4 records, chances are 
your search is matching at least two. Put a few more records in your 
database and it should start returning results.

On Wednesday, July 30, 2003, at 09:25 AM, Chad Day wrote:

my query:
SELECT  * FROM  `links` WHERE  MATCH ( KEYWORDS ) AGAINST (  'paper' );
I have a table with 4 records in it of links to various newspapers, 
paper
and newspaper are both in the keywords field.
The keywords field has a fulltext index on it.  Did I totally miss a 
step
somewhere?  The query doesn't error, I just get 0 results back.

Thanks,
Chad Day
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]