1、按位与
select * from cinema WHERE id&1;
2、id先除以2然后乘2 如果与原来的相等就是偶数
select * from cinema WHERE id=(id>>1)<<1;
3、正则匹配最后一位
select * from cinema WHERE id regexp '[13579]$';
select * from cinema WHERE id regexp '[02468]$';
4、id计算
select * from cinema WHERE id%2 = 1;
select * from cinema WHERE id%2 = 0;
select * from cinema WHERE mod(id, 2) = 1;
select * from cinema WHERE mod(id, 2) = 0;
5、1的奇数次方和偶数次方
select * from cinema WHERE POWER(-1, id) = -1;
select * from cinema WHERE POWER(-1, id) = 1;