Mysql子查询导致 "where"子句

Question

这样可以执行mysql查询吗？

select (select A from B where ... ) as C from D where C like ' ... '

我需要在一般的“where”子句中使用子查询的结果。

Answer 1

您可以将其包装在这样的子查询中:

SELECT * 
FROM (
        select (select A from B where ... ) as C from D
     ) subq
WHERE 
    C like ' ... '