List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 29 2002 6:21pm
Subject:Re: Results relevance
View as plain text  
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


Thread
Results relevanceMouratidis29 Apr
  • RE: Results relevanceGurhan Ozen29 Apr
    • MySQl 3.23.39 ..Richard Idalski29 Apr
    • Re: Results relevanceMouratidis29 Apr
      • Re: Results relevancePaul DuBois29 Apr
        • Re: Results relevanceJim Philips29 Apr
    • Re: Results relevanceMouratidis29 Apr
      • Re: Results relevanceJayce^29 Apr
      • RE: Results relevanceGurhan Ozen29 Apr
        • Re: Results relevanceMouratidis29 Apr
          • Re: Results relevanceKeith C. Ivey29 Apr
          • RE: Results relevanceGurhan Ozen30 Apr
            • Re: Results relevanceMouratidis30 Apr
      • Re: Results relevancePaul DuBois29 Apr
  • Re: Results relevanceBenjamin Pflugmann29 Apr
    • Re: Results relevancehassan29 Apr
  • Re: Results relevanceMouratidis29 Apr
    • Re: Results relevancePaul DuBois29 Apr