From: Daevid Vincent
Date: April 6 2004 12:29am
Subject: Why can't I use an "AS" value in the WHERE clause.
List-Archive: http://lists.mysql.com/mysql/163097
Message-Id: <200404060029.i360Tvs5001761@localhost.localdomain>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

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*