MySQL Forums
Forum List  »  Full-Text Search

Full Text Search Does Not Return Any Results
Posted by: Sean Gonsman
Date: February 19, 2008 02:39PM

I have a table with a FULL TEXT index. It does not appear to be returning any results when I do very simple queries. I have used FULLTEXT indexes before and they work great. I can't seem to figure this one out. Here is my basic query:

SELECT
users_searches_test.*
FROM
users_searches_test
WHERE
MATCH (users_searches_test.days) AGAINST ('+car' IN BOOLEAN MODE)

Does anyone know why this isn't working?

I am not sure if this is related but this table seems to have problems with the index cardinality. If I repair the table, the indexes seem fine, but once it get's updated the cardinality goes to "none". The table is small with only 92 rows right now so I am not sure if MySQL is saying that it doesn't need the indexes right now.

Thanks for any help you can provide.

Options: ReplyQuote


Subject
Views
Written By
Posted
Full Text Search Does Not Return Any Results
7758
February 19, 2008 02:39PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.