-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Well, you could just base the 100% off the highest returned value.
eg, if 3.95 is the highest return, then, that's your 100%, the others are just
percentages of that.
Jayce^
On Monday 29 April 2002 01:44 pm, Mouratidis wrote:
> Actually, that is exactly what I wanted to do! A bar graph for showing the
> relevance between the term I am searching for and the results I get from
> Mysql for a library system. I just don't know how to draw the bar (which is
> going to be a table cell in a table) if I cannot have something to compare
> it's value with.
> I mean, it is easy to dynamically draw a bar with Perl using HTML, but,
> what is the 100% ?
>
>
>
> ----- Original Message -----
> From: "Jim Philips" <[EMAIL PROTECTED]>
> To: "Paul DuBois Mouratidis" <[EMAIL PROTECTED]>;
> <[EMAIL PROTECTED]>
> Sent: Monday, April 29, 2002 8:15 PM
> Subject: Re: Results relevance
>
>
> 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
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org
iD8DBQE8zaqMoTgdT9hhlCIRAqZrAKCWX61dxha/Louf3jDaNkYDsQl0SwCfeAyY
Prpdjct4M6gwawISnibxArA=
=xfGx
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
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
