SELECT MATCH() AGAINST () MySQL Problem

[ppowell]

I'm trying to produce a relevancy score using the following querying structure:

SELECT MATCH (col1, col2, col3) AGAINST ('%hello%') AS score FROM myTable WHERE MATCH (col1, col2, col3) AGAINST ('hello' IN BOOLEAN MODE) ORDER BY score DESC

I am in need of some assistance in this type of querying. Problem is that on occasions my relevancy score comes across as 0 (not even a floating point number, just the integer 0), however, the results come back with matches; sometimes my score comes across as "INF' which is PHP's version of "Infinity".

I am not getting a "relevant" relevancy score. I'm using MySQL 4.0.17.

Thanks

Phil