List:General Discussion« Previous MessageNext Message »
From:Adam Date:April 6 2004 1:04pm
Subject:Re: Why can't I use an "AS" value in the WHERE clause.
View as plain text  
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
>

Thread
Why can't I use an "AS" value in the WHERE clause.Daevid Vincent6 Apr
  • Re: Why can't I use an "AS" value in the WHERE clause.Paul DuBois6 Apr
    • Re: Why can't I use an "AS" value in the WHERE clause.Joe Rhett6 Apr
    • Re: Why can't I use an "AS" value in the WHERE clause.(Pete Harlan)6 Apr
      • Re: Why can't I use an "AS" value in the WHERE clause.Michael Stassen7 Apr
  • Re: Why can't I use an "AS" value in the WHERE clause.Matt W6 Apr
  • Re: Why can't I use an "AS" value in the WHERE clause.Adam7 Apr
    • Re: Why can't I use an "AS" value in the WHERE clause.Michael Stassen7 Apr
      • Re: Why can't I use an "AS" value in the WHERE clause.Adam8 Apr
        • Re: Why can't I use an "AS" value in the WHERE clause.Michael Stassen8 Apr
          • Re: Why can't I use an "AS" value in the WHERE clause.Adam10 Apr