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.