On 09-Apr-2001 Eric Fitzgerald wrote:
> Since MATCH is evaluated AFTER the where, you need to use HAVING
> SELECT
> url,newwebsites.description,newwebsites.title,newwebsites.catid,category.ful
> lname,MATCH
> newwebsites.description AGAINST ('aliens') as GOO from newwebsites,category
> LEFT
> JOI
Hi,
You can't use aliases in a where, but you can in a HAVING clause.
Regards
Quentin
-Original Message-
From: Brad Barnett [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 10 April 2001 8:44 a.m.
To: [EMAIL PROTECTED]
Subject: Strange queries
SELECT
url,newwebsites.descri
Original Message -
From: "Brad Barnett" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 09, 2001 1:43 PM
Subject: Strange queries
> SELECT
>
url,newwebsites.description,newwebsites.title,newwebsites.catid,category.ful
lname,MATCH
> newwebsites.de
SELECT
url,newwebsites.description,newwebsites.title,newwebsites.catid,category.fullname,MATCH
newwebsites.description AGAINST ('aliens') as GOO from newwebsites,category LEFT
JOIN userrestrictions ON userrestrictions.name REGEXP
'[[:<:]]username|GLOBALAUTHADMIN[[:>:]]' AND
newwebsites.catid=user
