mysql - SELECT cols, (SELECT 内部查询) AS innercol FROM 表 WHERE innercol 某事

Question

只要我避免 WHERE stream_json ... 这可以修复还是需要 JOINS？

SELECT id, stuff,
    (SELECT count(*) 
     FROM inner_table
     WHERE inner_table.movie_id = outer_table.id) 
          AS stream_json
FROM outer_table 
WHERE stream_json != 0

Answer 1

您可以使用HAVING来访问使用WHERE子句无法接受的自定义别名

SELECT (SELECT count(*) FROM inner_table
WHERE inner_table.movie_id = outer_table.id) AS stream_json
FROM outer_table HAVING stream_json != 0

See this for reference