MYSQL IN 语句
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/8837584/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
提示：将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间：2020-08-31 22:21:02 来源:igfitidea点击:
MYSQL IN statement
提问by panthro
Im using INto select stuff...
我IN用来选择东西...
WHERE categories IN ("red", "blue", "green")
This selects any item in red, blue or green categories, my question is, is there a way to select an item that has to be in all three categories?
这将选择红色、蓝色或绿色类别中的任何项目，我的问题是，有没有办法选择必须属于所有三个类别的项目？
回答by Joe Stefanelli
SELECT Item
FROM YourTable
WHERE categories IN ('red', 'blue', 'green')
GROUP BY Item
HAVING COUNT(DISTINCT categories) = 3
回答by PatrickH
SELECT Item
FROM YourTable
WHERE categories ALL ('red', 'blue', 'green')
