If the final goal of this is a visual display, maybe it would make more sense
to display relevance as a horizontal bar graph that is longer or shorter
based on the relevance number. There is no reason to get hung up on
percentages.
On Monday 29 April 2002 02:21 pm, Paul DuBois wrote:
> 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
---------------------------------------------------------------------
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
