Re: How to convert text relevance value to percentage values (Calculate % in Query)

[News Heat Dot Com]

A way to Calculate the percentages on the fly is as follows:
SELECT
a.randomfield1
, MATCH(a.field1) AGAINST('search_text') as relevance
, b.maxrelevance
, (MATCH(a.field1) AGAINST('search_text'))/b.maxrelevance*100 as relevanceperc
FROM
table1 a
, (SELECT MAX(MATCH(field1) AGAINST('search_text')) as maxrelevance FROM table1 LIMIT 1) b
WHERE
MATCH(a.field1) AGAINST('search_text')
ORDER BY
relevance DESC;

This query was built on MySQL version 4.1.7



Edited 1 time(s). Last edit at 05/03/2007 08:04AM by News Heat Dot Com.