Posted by Captain Paralytic on 01/30/07 14:24

On 30 Jan, 13:56, "pwieg...@gmail.com" <pwieg...@gmail.com> wrote:
> Hi,
>
> I'm trying to use the result of a conditional statement in a where
> clause, but i'm getting 1)nowhere 2) desperate :-)
>
> The query is simple:
> --------
> SELECT
> idUser,
> (@ageraw:=YEAR(CURRENT_DATE()) - YEAR(dateofbirth) -
> (RIGHT(CURRENT_DATE(),5)<'12-31')) AS temp,
> @age:=if( @ageraw > 100,0,
> if( @ageraw < 10,0 ,
> @ageraw
> )) as age
> from users u
> ---------
>
> this works as a charm. But now I want to select users of a certain
> age, and I add a where clause:
> from users u having @age<50
>
> This is not working. Nor is any other variant I can think of. How can
> this be achieved?
>
> greeting, and many thanks,
>
> Paul

I would have expected it to be
from users u having age<50

• Next in forum: Re: Urgent please reply web application in Client server Program
• Prev in forum: event calendar problem
• Thread view: Re: using conditional statements in where-clause

[Reply to this message]