Dean,
Friday, August 02, 2002, 3:36:44 AM, you wrote:
DH Okay, I thought I'd done this before but maybe not. I can't figure it out
DH now.
DH What I want to do is:
DH SELECT column AS something FROM table WHERE something 5
You can use aliases and HAVING clause for them:
have a look at the HAVING clause:
mysql SELECT user,MAX(salary) AS sum FROM users
-group by user HAVING sum10;
http://www.mysql.com/doc/S/E/SELECT.html
Okay, I thought I'd done this before but maybe not. I can't figure it
out now.
What I want to do is:
SELECT column AS
Okay, I thought I'd done this before but maybe not. I can't figure it out
now.
What I want to do is:
SELECT column AS something FROM table WHERE something 5
Basically I'm creating a new column called something and I want to use it to
compare with in the WHERE condition. Is this possible?