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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
