mysql case when 使用

SELECT 
SIGN,
CASE 
WHEN STATUS=1 OR TYPE='sh' THEN '男'  
WHEN STATUS=0 THEN '女'
ELSE '其他'
END AS colm1,
CASE STATUS
WHEN '1' OR '3' THEN '男'
WHEN '2' THEN '女'
ELSE '其他'
END AS colm2
FROM `gegu` g