Page 1 of 1

Full Text Search - display relevance as a percentage

Posted: Thu Sep 30, 2004 2:37 pm
by muppet
Can any one help please, i ve checked previous posts on this and mysql.com but cannot seem to find out how to display the relevance as a percentage.

Any advice much appreciated

Thanks :?

Posted: Thu Sep 30, 2004 2:49 pm
by feyd
I was going to suggest this basic approach:
http://www.chuggnutt.com/2004/03/17/updated_search.html

found through: [google]+mysql ~"full text search" ~relevance ~percentage[/google]

Posted: Thu Sep 30, 2004 3:00 pm
by muppet
I've been trawling through some of these sites and either i'm stupid (most likely) or it just isn't obvious. I've contacted chugnut to see what advice he can offer.

Thanks for your reply, much appreciated :-)

Posted: Thu Sep 30, 2004 3:50 pm
by feyd
the relevence is reported back as a decimal number, when ordered in decending order, the first relevance rating is 100%. Multiply this number by 100, then divide the result by each of the following relevances and you'll receive a new decimal. This is a percentage of the first in their relevance.