Re: Results relevance

2002-04-30 Thread Mouratidis
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 unders

RE: Results relevance

2002-04-29 Thread Gurhan Ozen
[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 w

Re: Results relevance

2002-04-29 Thread Keith C. Ivey
On 29 Apr 2002, at 21:45, Mouratidis wrote: > 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 per

Re: Results relevance

2002-04-29 Thread Paul DuBois
At 20:44 +0100 4/29/02, 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

Re: Results relevance

2002-04-29 Thread Mouratidis
t; <[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 th

RE: Results relevance

2002-04-29 Thread Gurhan Ozen
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 can

Re: Results relevance

2002-04-29 Thread Jayce^
lt;[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 shor

Re: Results relevance

2002-04-29 Thread Mouratidis
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

Re: Results relevance

2002-04-29 Thread Jim Philips
TED]> > > >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) AGAI

Re: Results relevance

2002-04-29 Thread Paul DuBois
quot; <[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; >&

Re: Results relevance

2002-04-29 Thread Paul DuBois
lete it and ignore it. >Again, my apologies. > > >- Original Message - >From: "Benjamin Pflugmann" <[EMAIL PROTECTED]> >To: "Mouratidis" <[EMAIL PROTECTED]> >Cc: <[EMAIL PROTECTED]> >Sent: Monday, April 29, 2002 4:46 PM >Subjec

Re: Results relevance

2002-04-29 Thread Mouratidis
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 i

Re: Results relevance

2002-04-29 Thread Mouratidis
<[EMAIL PROTECTED]> Sent: Monday, April 29, 2002 4:46 PM Subject: Re: Results relevance > Hi. > > Could you please stop asking the same question again and again? > Meanwhile, you sent it at least four times within half a day. If > somebody knows an answer, one post is usuall

Re: Results relevance

2002-04-29 Thread hassan
ok, here is an example query "SELECT IDArticle, MATCH (ArticleTitle, ArticleContent, Keywords) AGAINST ('$keyword') AS relevance FROM article WHERE MATCH (ArticleTitle, ArticleContent, Keywords) AGAINST ('$keyword')" basicly you have to select the match statement too; this will not return a pe

Re: Results relevance

2002-04-29 Thread Benjamin Pflugmann
Hi. Could you please stop asking the same question again and again? Meanwhile, you sent it at least four times within half a day. If somebody knows an answer, one post is usually enough. Bye, Benjamin. On Mon, Apr 29, 2002 at 11:38:14AM +0100, [EMAIL PROTECTED] wrote: > Anybody knows

RE: Results relevance

2002-04-29 Thread Gurhan Ozen
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 welc

Results relevance

2002-04-29 Thread Mouratidis
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 p

Results relevance

2002-04-29 Thread Mouratidis
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 pos