%.
- 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
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
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
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
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
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
, 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 usually enough.
Bye,
Benjamin.
On Mon, Apr 29, 2002 at 11:38:14AM
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
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
Subject: Re: Results relevance
Hi.
Could you please stop asking the same question again
, 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
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
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
, 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
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
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 a
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
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
17 matches
Mail list logo