Just put the _expression_ in the WHERE clause as well:
> SELECT
> Name,
> dob,
> year(current_date) - year(dob) -
> (if(dayofyear(dob)>dayofyear(current_date),1,0)) AS Age
> FROM cand
> WHERE 1=1
> AND year(current_date) - year(dob) -
> (if(dayofyear(dob)>dayofyear(current_date),1,0)) > 1
> -----Original Message-----
> From: Spectrum WebDesign [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 27, 2004 10:35 AM
> 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]
- OT - Getting age from MySQL Spectrum WebDesign
- RE: OT - Getting age from MySQL Barney Boisvert
- RE: OT - Getting age from MySQL Greg Luce
- RE: OT - Getting age from MySQL Philip Arnold
- RE: OT - Getting age from MySQL Spectrum WebDesign