Is it possible to execute mysql query like this?
select (select A from B where ... ) as C from D where C like ' ... '
I need to use the result of subquery in general "where" clause.