将根据查询结果来修改字段值 select id,name,( case sex when ‘1’ then ‘男’ when ‘2’ then ‘女’ else ‘其他’ end ) from student;