select * from table where a between 1 and 156
但现在只想查找为双数的记录?
select * from table where a in(2,4,6,8,10...........)
这样太长了..
------解决方案--------------------
select * from table where a%2=0 and a <=156
------解决方案--------------------
select * from table where a between 1 and 156
and a%2=0
------解决方案--------------------
同意wym840713()这位兄弟的select * from table where a between 1 and 156 and a%2=0,另一位兄弟的select * from table where a%2=0 and a <=156可以取到0,这点不符合你的要求