select 不是记得有个where in的用法，怎么不行了

shang2010

select * from test where name in  ('zhang1', 'li2', 'wang3');

maochanglu

啥错误信息啊

ruochen

1. root@localhost:test 12:59:14>select * from t1;
   
2. +---+
   
3. | a |
   
4. +---+
   
5. | 0 |
   
6. | 0 |
   
7. | 1 |
   
8. | 2 |
   
9. | 3 |
   
10. | 3 |
    
11. | 4 |
    
12. | 4 |
    
13. | 5 |
    
14. | 5 |
    
15. | 6 |
    
16. | 6 |
    
17. | 7 |
    
18. | 7 |
    
19. | 8 |
    
20. | 8 |
    
21. | 9 |
    
22. | 9 |
    
23. +---+
    
24. 18 rows in set (0.00 sec)
    
25. 
    
26. root@localhost:test 12:59:18>select * from t1 where a in (0,1);
    
27. +---+
    
28. | a |
    
29. +---+
    
30. | 0 |
    
31. | 0 |
    
32. | 1 |
    
33. +---+
    
34. 3 rows in set (0.00 sec)
    
35. 
    
36. root@localhost:test 13:01:05>show create table t1\G;
    
37. *************************** 1. row ***************************
    
38.        Table: t1
    
39. Create Table: CREATE TABLE `t1` (
    
40.   `a` int(11) NOT NULL default '0',
    
41.   KEY `idx_t1_a` (`a`)
    
42. ) ENGINE=MyISAM DEFAULT CHARSET=latin1
    
43. 1 row in set (0.00 sec)
    

复制代码

yueliangdao0608

是有

shang2010

可以了，