mysql查询用if控制显示列

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

【推广】免费学中医，健康全家人

原文地址：https://www.cnblogs.com/wzk1992/p/5735447.html