mysql条件判断

1.ifnull(a,b) 如果a为null,就为b
* 空字符串不为null
* 判断字符串不为空: LENGTH(trim(str))>0;

2.if(expr1,expr2,expr3)
select if(sex = 1,'男','女')
select sum(if(a = 4, b, null))

SELECT 
CASE 
    WHEN sex=0 THEN '男'
    WHEN sex=1 THEN '女' 
    ELSE '未知' 
END as sex
FROM `user`