List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 6 2004 1:03am
Subject:Re: Why can't I use an "AS" value in the WHERE clause.
View as plain text  
At 17:29 -0700 4/5/04, 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;

I think you'll never be able to do it.

The stuff after the SELECT is calculated based on the rows selected
by the WHERE.  The WHERE therefore cannot be based on the stuff after
the SELECT.



>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*


-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

MySQL Users Conference: April 14-16, 2004
http://www.mysql.com/uc2004/
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