our DB have a field with dob from our clients. I'm looking for a script to calculate the age including WHERE clauses.
But MySQL give an error: Unknown column "Age" in where clause.
Please look:
SELECT
Name,
dob,
year(current_date) - year(dob) - (if(dayofyear(dob)>dayofyear(current_date),1,0)) AS Age
FROM cand
WHERE 1=1
AND Age > 1
How to do that?
Thanx in advance
--
___________________________________________________________
Sign-up for Ads Free at Mail.com
http://promo.mail.com/adsfreejump.htm
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
