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
原文：https://www.cnblogs.com/weibanggang/p/9672271.html