Hi.
On Apr 05, [EMAIL PROTECTED] wrote:
> >Description:
> Pretty simple, just try to do a "match(column) against ('text') in the
> HAVING clause of a SELECT statement. Restarts my database server every
> time.
I'm replying now just to assure I didn't miss your mail.
The bug i
to do this is to run the
Full-Text match AFTER I limit the result set with other criteria.
It works, but I'm trying for better performance.
>Submitter-Id:
>Originator:[EMAIL PROTECTED]
>Organization: CFOknows, LLC
>MySQL support: none
>Synopsis: Fu
t way than doing a count(*) but haven't
gotten any responses.
--Paul
-Original Message-
From: Oson, Chris M. [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 22, 2001 8:46 AM
To: [EMAIL PROTECTED]
Subject: Full-Text Query
Good Day All,
This will work...
mysql> SELECT story
Good Day All,
This will work...
mysql> SELECT storyID, title, summary, MATCH summary AGAINST (LCASE('news'))
AS probability
-> FROM newsStories WHERE MATCH summary AGAINST (LCASE('news')) > 0
LIMIT 0, 5;
But this will not...
mysql> SELECT COUNT(*), MATCH summary AGAINST (LCASE('news')) AS
