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
If you have only four records in the table, it's very likey that you're running into the 50% rule. (Words that occur in at least half the records are considered too common and ignored.)
You can test this by inserting a few more records that don't contain "paper". Or you can use IN BOOLEAN MODE, which ignores the 50% rule. (Available from MySQL 4.0.1 on.)
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]