SELECT name as '姓名',case sex when 1 then '男' when 2 then '女' else '其他' end as '性别' from tauser SELECT name as '姓名',if(sex=1,'男','女') as '性别' from tauser