At 17:50 +0100 4/29/02, Mouratidis wrote:
>Doing that will not give back a percentage or anything that can be used to
>calculate one (right?). I meant if there was a way to actually get a result
>that could be interpreted into a percentage somehow.
No. The values returned by a FULLTEXT search are simply non-negative
floating-point numbers. The larger the number within a result set,
the higher the relevance, but that doesn't map onto percentage.
>
>----- Original Message -----
>From: "Gurhan Ozen" <c-gurhan.ozen@stripped>
>To: "Mouratidis" <alex.mouratidis@stripped>; <mysql@stripped>
>Sent: Monday, April 29, 2002 3:58 PM
>Subject: RE: Results relevance
>
>
>> Hi,
>> You can just do
>> SELECT MATCH(column name) AGAINST ('searchstring') AS relevance FROM
>> tablename;
>>
>> There is an example at: http://www.mysql.com/doc/F/u/Fulltext_Search.html
>>
>> Gurhan
>>
>> -----Original Message-----
>> From: Mouratidis [mailto:alex.mouratidis@stripped]
>> Sent: Monday, April 29, 2002 6:38 AM
>> To: mysql@stripped
>> Subject: Results relevance
>>
>>
>> Anybody knows how to get a percentage out of the Relevance Mysql returns
>> when queried with the match() function?
>> I am using Perl, so if there are any scripts or modules that you know of,
>> those are also welcome.
>>
> > Alex
