MySql 帮助编写查询

Question

假设我有一个包含 3 列的表格，如下所示

 ------------------------------
|id | recipe_id | sub_category |
 ------------------------------
| 1 | 80        | 2            |
| 2 | 80        | 6            |
| 3 | 80        | 3            |
| 4 | 82        | 1            |
| 5 | 83        | 2            |
| 6 | 85        | 5            |
| 7 | 80        | 10            |
 ------------------------------

如何获取包含子类别 2 和 6 的食谱 id？是否可以使用mysql查询来获取它？

Answer 1

试试这个:

SELECT recipe_id
FROM mytable
WHERE sub_category IN (2, 6)
GROUP BY recipe_id
HAVING COUNT(DISTINCT sub_category) = 2

Demo here