第1个回答 2012-05-07
你上面的sql语句有问题,select uid from table1 where id in(1,2,3,4)就行了,干嘛还那么多4,我测试了下你的语句,完全没有去重啊,去重要加distinct的。
mysql> select * from test;
+------+------+
| uid | id |
+------+------+
| 1 | 1 |
| 2 | 2 |
| 3 | 1 |
| 4 | 1 |
| 5 | 2 |
| 6 | 3 |
| 7 | 4 |
| 8 | 2 |
| 7 | 4 |
| 4 | 3 |
| 2 | 3 |
| 4 | 7 |
+------+------+
12 rows in set (0.00 sec)
mysql> SELECT uid FROM test WHERE id IN (1,2,3,4,4,4,4);
+------+
| uid |
+------+
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 7 |
| 4 |
| 2 |
+------+
11 rows in set (0.00 sec)本回答被提问者采纳