select
u.*,
(case
when ORG_NATURE ='0' then '女'
when ORG_NATURE ='1' then '男'
end) as genderName
from User u
select
u.*,
(case
when ORG_NATURE ='0' then '女'
when ORG_NATURE ='1' then '男'
end) as genderName
from User u