%.
- 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
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:
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
15 matches
Mail list logo