Mysql 笔记

1.case

SELECT ID,NAME,CASE WHEN SEX='m' THEN 'f' ELSE 'm' END SEX, SALARY FROM SALARY

2.mod()

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