How to convert fulltext relevancy into percentage?

ppowell

If anyone here has ever worked with MySQL fulltext relevancy scores, how do you convert them from a rather large-decimal floating point number to a meaningful integer percentage scale?

For instance, if you have a score of 3.2572498321533 , how do you change that to [number]% that would be on a scale of 0 - 100%? Is there anything out there script-wise that already does that in PHP, TCL or Linux Shell Script?

Thanx
Phil

DRuCuLa

if i understood ur question,
how about multiplying by 100 and removing the fraction using round() or ceil() or floor()?
floor(3.2572498321533 100) => 325
ceil(3.2572498321533 100) => 326
round(3.2572498321533 * 100) => 326

PHP example:

echo floor(3.2572498321533 * 100) . "%";

outputs "325%"

ppowell

That wouldn't work, because I have 325%, which is beyond impossible. It would be no more than 100% relevancy (see Google search results to see what I mean). I thought of that too but I can't show the client "325%".

Phil

DRuCuLa

then...
what number is ur 100%?
100? 1?

ppowell

To be honest I have no idea as I do not know what the maximum relevancy score that could ever be returned as I have never seen it ever occur in any relevancy search.

Phil

DRuCuLa

and u want to convert it into percentage when u dont know the 100%... :bemused:

ppowell

I could never know it, no one can. This might help

re: http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html

How do I convert a relevancy score into a percentage with a ceiling of 100%? I can't find anything online that addresses this, and I am receiving relevancy scores > 0.2 that can be as high as 3.26.

Any ideas?

Thanx
Phil

DRuCuLa

oh, sorry. cant help u about that. never worked this way.

ppowell

I'm not sure who can either 🙁 Thanx for trying.

Phil