select * from test where status in ('01', '02', '03', '111');

select * from test where status = '01' or status = '02' or status = '03' or status = '111';

in查询比or要高10倍的效率

 

posted on 2016-11-17 15:37  maikec陈  阅读(10507)  评论(3编辑  收藏  举报