MySQL 查询 WHERE AND 和 OR 的组合

Question

我正在尝试获取表中属于“parent_id”(7 OR 8 OR 9 OR 10)AND 3 AND 14 的所有条目。

以下是伪代码。我需要更改什么才能使其正常工作？

SELECT news_id
FROM news_categories
WHERE 
    category_id IN (7,8,9,10) 
AND (
    category_id IN (3,14)
    GROUP BY news_id
    HAVING COUNT(category_id) = 2
)

预先感谢您给我带来的每一个提示;-)

Answer 1

SELECT news_id
FROM news_categories
GROUP BY news_id
HAVING sum(category_id IN (7,8,9,10)) > 0
and sum(category_id = 3) > 0
and sum(category_id = 14) > 0