一、两种(0表示男,1表示女)
SELECT if(sex="0","男",“女”)
FROM `emp`
二、多种
SELECT if(sex="0","男",if(sex="1","女",if(sex="2","二","无")))
FROM `emp`
一、两种(0表示男,1表示女)
SELECT if(sex="0","男",“女”)
FROM `emp`
二、多种
SELECT if(sex="0","男",if(sex="1","女",if(sex="2","二","无")))
FROM `emp`