Re: Strange queries

2001-04-09 Thread bbarnett
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

RE: Strange queries

2001-04-09 Thread Quentin Bennett
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.description,newwebsites.

Re: Strange queries

2001-04-09 Thread Eric Fitzgerald
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 JOIN userrestrictions ON userrestrictions.name REGEXP '[