mysql 的mod函数

select *
from cinema
where mod(id, 2) = 1 and description != 'boring'
order by rating DESC

mod可以取基数，或偶数