MYSQL IN语句 [英] MYSQL IN statement
本文介绍了MYSQL IN语句的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我使用 IN
选择项目...
WHERE类别IN(红色,蓝色,绿色)
,蓝色或绿色类别,我的问题是,有办法选择一个项目,必须在所有三个类别?
解决方案
pre> SELECT Item
FROM YourTable
WHERE类别IN('red','blue','green')
GROUP BY项目
HAVING COUNT(DISTINCT categories)= 3
Im using IN
to select stuff...
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?
解决方案
SELECT Item
FROM YourTable
WHERE categories IN ('red', 'blue', 'green')
GROUP BY Item
HAVING COUNT(DISTINCT categories) = 3
这篇关于MYSQL IN语句的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文