select case sex when '0' then '男' else '女' end as sss from table1
或者
select case sex when "0" then ('男') when "1" then ('女') when "3" then ('未知') else null end as `value`
select case sex when '0' then '男' else '女' end as sss from table1
或者
select case sex when "0" then ('男') when "1" then ('女') when "3" then ('未知') else null end as `value`