Re: Why can't I use an "AS" value in the WHERE clause.

[Michael Stassen]

Adam,

That won't work.  Daevid doesn't have a column named active.  Nor does he 
have to do the math twice.  As was pointed out earlier, he can do what he 
wants using HAVING instead of WHERE, like this:

   SELECT *,
   IF(((unix_timestamp()-unix_timestamp(last_seen)) < 600),1,0) active
   FROM wifi_table
   HAVING active = 1;

Michael

Adam wrote:

> Daevid,
> 
> SELECT *
>     FROM wifi_table
>  WHERE active = 1
>  HAVING unix_timestamp()-unix_timestamp(last_seen) < 600;
> 
> Regards,
> Adam
> 
> On Apr 5, 2004, at 8:29 PM, Daevid Vincent wrote:
> 
>> I'm curious when will I be able to do something like this:
>>
>> SELECT *, IF(( (unix_timestamp()-unix_timestamp(last_seen)) < 
>> 600),1,0) as
>> active FROM wifi_table WHERE active = 1;
>>
>> It's so obnoxious, especially since I can do this:
>>
>> SELECT *, IF(( (unix_timestamp()-unix_timestamp(last_seen)) < 
>> 600),1,0) as
>> active FROM wifi_table WHERE unix_timestamp()-unix_timestamp(last_seen) <
>> 600;
>>
>> Why do I have to do the math TWICE?!
>>
>> *sigh*