having condition on result of a subquery in mysql
Posted
by naiquevin
on Stack Overflow
See other posts from Stack Overflow
or by naiquevin
Published on 2010-05-13T07:06:16Z
Indexed on
2010/05/13
7:14 UTC
Read the original article
Hit count: 281
hi
i am trying to run a query like this
SELECT a, b , c, (SELECT INNULL(x,y)) as mycol WHERE mycol < 400 ;
BUt it gives the error
#1054 - Unknown column 'mycol' in 'where clause'
What would be the right way to do this?
Thanks.
© Stack Overflow or respective owner