SELECT Name, dob
FROM cand
WHERE (year(current_date) - year(dob) -
(if(dayofyear(dob)>dayofyear(current_date),1,0))) < 1
Let me know,
Greg
-----Original Message-----
From: Spectrum WebDesign [mailto:[EMAIL PROTECTED]
Sent: Friday, February 27, 2004 1:35 PM
To: CF-Talk
Subject: OT - Getting age from MySQL
Hi all
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]
