mysql 获取百分比结果,如何以百分比形式获取mysql匹配的结果？

I am using Match (Col1) Against (Val) in mysql.

select match(body) against(body_var) from articles;

now in case of completely match i am getting result as a number (for example 14.43).

what does this number mean? and the main question is can i get the result in percentage form (for example 0.94)

thanks for your help

解决方案

There is probably a MUCH easier way to do this.. Somehow i fell down the rabbit hole on this one.. But its tested and works (returns percentage of results)

SELECT (mthCount / ttlCount) AS mPercent

FROM (

SELECT COUNT( * ) AS mthCount

FROM articles WHERE (

MATCH(body) AGAINST(body_var)

)

) AS MCount JOIN (

SELECT COUNT( * ) AS ttlCount

FROM articles

) AS TCount;

it returns one record/result with the column mPercent

You could also have it round to two decimal places...

SELECT FORMAT((mthCount / ttlCount),2) AS mPercent

FROM (

SELECT COUNT( * ) AS mthCount

FROM articles WHERE (

MATCH(body) AGAINST(body_var)

)

) AS MCount JOIN (

SELECT COUNT( * ) AS ttlCount

FROM articles

) AS TCount;

As i said.. I tested it against 358 rows with 50 matches

50/350 = 0.1396648... (for first result)

0.14 for rounded result

If you are looking to convert the relevance value to a percent for a single result - it isnt really going to happen...

The relevance value from the MATCH/AGAINST is not a good indicator of percent match.. This is covered in depth throught the internet.. Search for "Convert Relevance value to percent" ...

If you wanted to order your results by relevence match percent, with the first result always having 100% relevence, you can do that...

As for trying to get a value like PHP's similar_text - you are better to offload that work to the client...