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" <[EMAIL PROTECTED]>
>To: "Mouratidis" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>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:[EMAIL PROTECTED]]
>> Sent: Monday, April 29, 2002 6:38 AM
>> To: [EMAIL PROTECTED]
>> 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
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
