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 END18 ) 注册来源 19 FROM20 tb_userInfo t