create table test( 
id int primary key auto_increment, 
name varchar(20), 
sex int  
) 
insert into test(name,sex) values('小明',1),('小兰',0),('小邹',1),('小孟',0) 
 
select id ,name ,if(sex=1,'男','女') from test 
 
select id ,name ,case sex when 1 then '男' else '女' end as sex from test