mysql storing subquery in column and performing where condition
<p>i am performing a sub query in mysql which is like</p>

<pre><code>select col1, col2 , (select col3 from table2) as 'data'
from table1 
where not data is null
</code></pre>

<p>how should i get data in where clause. IS it POSSIBLE</p>