sql 语句 select 后结果 删除重复，只保留一条

Question

select * from table where item_id in (10,23,12);
+-------+-----------------+
| id    |         item_id |
+-------+-----------------+
|  9362 |         10      |
|  9440 |         10      |
|  5806 |         10      |
|  6945 |         23      |
|  6946 |         23      |
+-------+-----------------+
5 rows in set (0.00 sec)

针对上面 select 结果 删除 item_id 重复数据，只保留一条，

求 sql 语句

id 为主键，数据库 是 mysql 5.5

Answer 1

select * from table where item_id in (10,23,12) group by item_id