MySQL Forums
Forum List  »  Full-Text Search

problem with normal match against
Posted by: Fire Wizard
Date: July 10, 2006 11:46PM


I have a problem with a fulltext search. I used to run it on a 4.1 MySQL server and it worked ok, then I moved the code and databases to a MySQL 5.0 server and this query doesn't work anymore:

SELECT name, MATCH(name, content) AGAINST('baseball') AS relevance HAVING relevance > 0 ORDER BY relevance DESC

The FULLTEXT INDEX is (name, content) of course. If I remove the HAVING clause, i see that ALL the rows return relevance 0, althoug the word "baseball" exists in 6 of 200 rows. If i run the same query in boolean mode those 6 rows return a relevance of 1, which really shows that the word exists.

Any idea why this happens? I don't want to change this query to use "in boolean mode", I think relevance should work. Do
I have to configure the server in any way? Do i have to reindex my table? Please help!

Thank you in advance

Edited 1 time(s). Last edit at 07/11/2006 01:01AM by Fire Wizard.

Options: ReplyQuote

Written By
problem with normal match against
July 10, 2006 11:46PM

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.