MySQL子查询结果为"where".条款 [英] Mysql subquery result in "where" clause

问题描述

是否可以像这样执行mysql查询?

Is it possible to execute mysql query like this?

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

我需要在一般的"where"子句中使用子查询的结果.

I need to use the result of subquery in general "where" clause.

推荐答案

您可以将其包装在子查询中，如下所示:

You can wrap it in a sub-query like this:

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

这篇关于MySQL子查询结果为"where".条款的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！