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: 282

Filed under:
|
|

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

Related posts about mysql

Related posts about subquery