tslice
05-28-2008, 01:27 PM
I created a fulltext index for the table articles on two columns head and article where each row is unique. The query: SELECT * FROM articles WHERE MATCH (head, article) AGAINST ('frog') LIMIT 0, 10 returns no results. The cardinality is 1 even though I have over 33,000 rows in the table. I don't know what I'm doing wrong. I've read several tutorials, browsed the mysql manual, and searched forums. HELP!