s_num是数值 select * from s_info where s_num>=100 and s_num<=200 s_num是字符 select * from s_info where s_num>='100' and s_num<='200'
select * from s_info where s_num>=100 and s_num<=200
select * from s_info where s_num BETWEEN 100 AND 200
你可以选择以下几种: select * from s_info where s_num in(100,200)select * from s_info where s_num between 100 and 200select * from s_info where s_num>=100 and s_num<=200
select * from s_info where s_num>=100 and s_num<=200
s_num是字符
select * from s_info where s_num>='100' and s_num<='200'
select * from s_info where s_num in(100,200)select * from s_info where s_num between 100 and 200select * from s_info where s_num>=100 and s_num<=200