sql查某个字段为奇数的写法

大概想到的是这几种写法

select * from contract where con_id>0 and con_id%2!=0 0.31067705154419秒
select * from contract where con_id>0 and mod(con_id,2)=1 0.31990098953247秒
select * from contract where con_id>0 and con_id & 1 = 1 0.30721592903137秒
select * from contract where con_id>0 and (con_id>>1)<<1 0.55917406082153秒

根据执行时间来看的话，用位运算 比较快