1 SELECT DISTINCT 2 ( 3 CASE 4 WHEN t.fromType = ‘1‘ 5 THEN ‘关羽‘ 6 WHEN t.fromType = ‘2‘ 7 THEN ‘ 张飞‘ 8 WHEN t.fromType = ‘3‘ 9 THEN ‘ 赵云‘ 10 WHEN t.fromType = ‘4‘ 11 THEN ‘ 马超‘ 12 WHEN t.fromType = ‘5‘ 13 THEN ‘ 黄忠‘ 14 WHEN t.fromType = ‘6‘ 15 THEN ‘ 魏延‘ 16 ELSE ‘ 其他‘ 17 END 18 ) 注册来源 19 FROM 20 tb_userInfo t
结果如下：
原文：http://www.cnblogs.com/rmb-mylove123/p/5829979.html