List:General Discussion« Previous MessageNext Message »
From:Matt W Date:April 6 2004 2:15am
Subject:Re: Why can't I use an "AS" value in the WHERE clause.
View as plain text  
Hi,

This is what HAVING is for.  :-)


Matt


----- Original Message -----
From: "Joe Rhett"
Sent: Monday, April 05, 2004 8:59 PM
Subject: Re: Why can't I use an "AS" value in the WHERE clause.


> On Mon, Apr 05, 2004 at 08:03:33PM -0500, Paul DuBois wrote:
> > 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.
>
> So why not the reverse?  Allow aliasing in the WHERE clause, that we
can
> use in the select clause.  Probably not ANSI, but MySQL isn't shy
about that.

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