CASE + LIKE 方法

SELECT 
CASE 
WHEN profile LIKE '%,male' then 'male'
WHEN profile LIKE '%,female' then 'female'
else '其他'
end as gender,
COUNT(*) AS number 
FROM user_submit
GROUP BY gender;

• 注意famale 和 male 有重合的地方，所以不能直接like male，否则female 也会被统计进 ‘male’