You are probably right. What I meant was just that, like you said, this
method will only return a value based on what is already in the database.
My understanding is that the relevance value Mysql returns, also depends on
a comparison between the search term and the result.
For the example I gave, it would be something like: compare ("Another",
"Another book about Perl"). I should probably better get Perl to do
that comparison, instead of asking Mysql to do it. It just seemed to me like
the values Mysql returns for relevance are lowering as this
comparison between the two strings reaches 100%.----- Original Message ----- From: "Gurhan Ozen" <[EMAIL PROTECTED]> To: "Mouratidis" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, April 30, 2002 3:57 AM Subject: RE: Results relevance > Alex, > I am not really understanding what exactly you are trying to do as far as > "relevance" goes. First of all, The example I gave you was based on > baselining . Depending on the common values most search return, you can > choose another value. > When you do a fulltextsearch, it returns a result set and the only the > relevance can only be be in terms of relevance of records between each > other. The record which is the most relevant to the search query in that > result set would have the highest revelance which is 100% . > Your example didn't make sense to be , if the search term is "Another" , > then "Another book about Perl" could sure be 100% relevant... What did you > mean by "doesn't look right as it is considerably off the real relevance." ? > It sure has the word "About" ... > > Gurhan > > -----Original Message----- > From: Mouratidis [mailto:[EMAIL PROTECTED]] > Sent: Monday, April 29, 2002 4:45 PM > To: [EMAIL PROTECTED] > Subject: Re: Results relevance > > > Problem is, relevance can be anything. It could be 3.6 for example, and > multiplying that with a 100 will give me a number > 100. The way I had done > it was to divide all results with the highest value of relevance and get > something that was a percentage. But, if you do that, then if you have for > example a search for the term: > > 'Another' > > and the best match is 'Another book about Perl', then this match is > displayed as 100%. Which obviously, doesn't look right as it is considerably > off the real relevance. > > ----- Original Message ----- > From: "Gurhan Ozen" <[EMAIL PROTECTED]> > To: "Mouratidis" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Monday, April 29, 2002 9:33 PM > Subject: RE: Results relevance > > > > Hi, > > You can take 1.00 as baseline for 100%. Just multiply the relevance number > > by 100.. For the relevance that are greater than 1.00 you will have a > > number greater than zero and for everything else it will be smaller than > or > > equal to 100. > > In your code, do something accomplish: > > > > if relevance is > 100 then > > print <td width="100%" bgcolor="..."> > > > > else > > print <td width=$rel% bgcolor="...."> > > > > This way you will have the percentage of the table colored with a > > different background color.. > > > > Worth for noting, fulltext search returns no results if the search string > is > > in more than half of the rows. If you are coding for a library system and > > especially when there are searches for a common keyword based on a > specific > > category, you might want to take this fact into consideration. > > Sincerely, > > Gurhan > > > > > > -----Original Message----- > > From: Mouratidis [mailto:[EMAIL PROTECTED]] > > Sent: Monday, April 29, 2002 3:45 PM > > To: [EMAIL PROTECTED] > > Subject: Re: Results relevance > > > > > > 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 > > > > > > > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- 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
