problem with normal match against

[Fire Wizard]

Greetings,

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.