mysql - 检查同一列mysql查询中的不同数据值？

Question

id_detail_item id_item   id_detail_item_name
1              1         abc 
2              1         abcd
3              1         cde
4              3         zki
5              3         zkr

如何检查同一个“id_item”中的“id_detail_item_name”是否有两个不同的数据？

我已尝试以下操作，但出现错误:

SELECT id_item FROM table_detail_item WHERE id_detail_item_name='abc' AND id_detail_item_name='abcd';

Answer 1

这应该列出 id_item 至少具有两个不同 id_detail_item_name 的所有条目

SELECT id_item, MIN(id_detail_item_name) nam1,max(id_detail_item_name) nam2 
FROM table_detail_item 
GROUP by id_item HAVING MIN(id_detail_item_name) nam1<MAX(id_detail_item_name)