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

[Adam]

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*
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    
> http://lists.mysql.com/mysql?unsub=1
>