select case
when sex='0' then 'man'
when sex='1' then 'woman'
else 'just so so ' end
from user;
select case sex
when '0' then 'man'
when '1' then 'woman'
else 'just so so ' end
from user;
select case
when sex='0' then 'man'
when sex='1' then 'woman'
else 'just so so ' end
from user;
select case sex
when '0' then 'man'
when '1' then 'woman'
else 'just so so ' end
from user;