mysql - "Subquery returns more than 1 row"错误

Question

我读了很多帖子，但我无法理解要写的错误和我的查询。

我想要那个拥有超过 1000 个赞的 poster_id

SELECT * FROM `posters` 
WHERE title LIKE '%it%'
AND id = (
    SELECT poster_id FROM `poster_likes`
    WHERE action=1
    GROUP BY poster_id
    HAVING COUNT(*) < 100
  )

子查询返回多行。

谁能帮我写下这个查询。提前致谢。

Answer 1

您可能想使用 IN() 而不是 =:

SELECT * FROM `posters` 
WHERE title LIKE '%it%'
AND id IN (
    SELECT poster_id FROM `poster_likes`
    WHERE action=1
    GROUP BY poster_id
    HAVING COUNT(*) < 100
  )