mysql case when

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