SELECT
userid,code,
(case
when (code='010') then '大连'
when (code='020') then '北京'
else '其他' end
) AS city
FROM
userInfo
SELECT
userid,code,
(case
when (code='010') then '大连'
when (code='020') then '北京'
else '其他' end
) AS city
FROM
userInfo