mysql - 当列必须满足多个值时如何选择行？

Question

比如我有一张 table

name | ability

kevin|say
kevin|scream
nike |say

在寻找 say 和 scream 时，我只想得到 kevin 的回应。参数的数量可能会改变。

Answer 1

您可以使用 group by 和 having 来做到这一点:

SELECT name
FROM t
WHERE ability in ('say', 'scream')
GROUP BY name
HAVING COUNT(*) = 2;