mysql查询用if控制显示列

1: select *,if(sex=1,”男”,”女”) as sex from user
2: select CASE sex WHEN 1 THEN ‘男’ ELSE ‘女’ END as sex from user