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
[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
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
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
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
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
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
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
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
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;
>&
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
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
<[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
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
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
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
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
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
18 matches
Mail list logo