FULLTEXT MATCH SCORE

[da644]

Can anyone tell me the maximum value that can be returned on a FULLTEXT select using the MATCH function.

For example:-

select MATCH(textField) AGAINST ('HELLO') as score
from tableName
where MATCH(textField) AGAINST ('HELLO') as score

You get scores back like 0.62 and 2.4 and stuff... anyone know the maximum so I can turn this number into a precentage???

Thanks

Andrew
andrew@clickitstudios.com

http://www.clickitstudios.com