mysql case when

信息屋

于 2017-05-27 15:00:20 发布

阅读量536

点赞数

分类专栏： mysql 文章标签： mysql

本文链接：https://blog.youkuaiyun.com/su12345su/article/details/72781475

版权

mysql 专栏收录该内容

10 篇文章

订阅专栏

mysql case when

SELECT id,`code`,descript,descript_en ,date_begin,date_end,
CASE points_rule WHEN 1 THEN '小于' WHEN 2 THEN '大于' ELSE '' END AS points_rule,points,
CASE nights_rule WHEN 1 THEN '小于' WHEN 2 THEN '大于' ELSE '' END AS nights_rule,nights,
iss_hotel,card_src,card_type_old,card_level_old,card_type_new,card_level_new, reason,
CASE times_in_rule WHEN 1 THEN '小于' WHEN 2 THEN '大于' ELSE '' END  AS times_in_rule,times_in,
CASE times_cxl_rule WHEN 1 THEN '小于' WHEN 2 THEN '大于' ELSE '' END AS times_cxl_rule,times_cxl,
CASE times_noshow_rule WHEN 1 THEN '小于' WHEN 2 THEN '大于' ELSE '' END AS times_noshow_rule,
times_noshow,remark,priority,modify_user,modify_datetime FROM card_auto_up_down_grade 
WHERE hotel_group_id =  2 AND hotel_id =0 AND (1=1) ORDER BY priority