mysql 怎麽使用 if，switch

SELECT id,case status WHEN '0' then '審核中' WHEN '1' then '通過' WHEN '3' then '禁用' end as "status" from tp_user

if的用法：

select *,if(sex=1,"男","女") as sex from tp_user