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
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
At 9:25 -0400 7/30/03, 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