select CASE WHEN t.Id = 1 THEN '饮' WHEN t.Id = 2 THEN '零' ELSE '无选择' END idName from table //如果为1 结果饮