这个SQL语句该怎样修改?

[xwqjamky]

select * from table where a between 1 and 156


但现在只想查找为双数的记录?

select * from table where a in(2,4,6,8,10...........)
这样太长了..

[鐵蛋]

同意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,这点不符合你的要求

[akuzou]

select * from table where a%2=0 and a<=156

[wym840713]

select * from table where a between 1 and 156
and a%2=0