mysql 中的case 和when的简单用法

mysql> select id,type from t_user where id=93;
+----+------+
| id | type |
+----+------+
| 93 |    1 |
+----+------+
1 row in set

mysql> select id, case type when 1 then '商家' when 2 then '用户' end as '用户类型' from t_user where id=93;
+----+----------+
| id | 用户类型 |
+----+----------+
| 93 | 商家     |
+----+----------+
1 row in set

mysql>