case when在mysql中,可以用于改变一些查询值,也可以用来动态拼接一些语句:
改变查询值:
select (case "sex" when "0" then "男" when "1" then "女" else "妖" end) "性别" from "student";
用以统计:
select sum(case id when 1 then 11 else 1 end) ss from ad_coupon;
用以添加查询:
select * from ad_coupon where (case when id>1 then create_time>'2018-09-01' else 1=1 end);