Mysql查询case-when将列里面的值替换为别的值但是实际值不变

1、普通查询：

select register_state registerState,count(*) count from xxxx
where del_state=0 GROUP BY register_state;

查询结果如图：

2、特殊查询，根据某个字段的值，赋给它另一个相应的值

select register_state registerState,
(case register_state when -1 then '注册审核不通过' when 0 then '待审核' when 1 then '注册审核通过' end) registerStateReal,
count(*) count from xxxx
where del_state=0 GROUP BY register_state;

查询结果如图：