Hello
> We use MySQL 3.23.32, so I recently added a FULLTEXT index for this
> field on all forums and changed the source code to make use of the
> MATCH() AGAINST() MySQL call.
If you make FULLTEXT queries over many tables, and combine the results
afterwards, you might get into problems with 3.2
nal Message -
From: "Noor Dawod" <[EMAIL PROTECTED]>
To: "Jason Terry" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, February 13, 2001 9:23 AM
Subject: RE: TEXT's are giving us headaches!
> Hi
>
> Hmm, this seems to me like redundant
rom: Jason Terry [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 13, 2001 6:07 PM
To: Noor Dawod
Cc: [EMAIL PROTECTED]
Subject: Re: TEXT's are giving us headaches!
A mistake I made for a long time with MATCH AGAINST is to not include it
in the WHERE clause
eg I did
SELECT ID,MATCH Q,A
A mistake I made for a long time with MATCH AGAINST is to not include it in the WHERE
clause
eg I did
SELECT ID,MATCH Q,A AGAINST ("This") AS Score FROM faq
instead of
SELECT ID,MATCH Q,A AGAINST ("This") AS Score FROM faq WHERE MATCH Q,A AGAINST ("This")
The latter will give much better perfo
