图片说明
转自https://www.cnblogs.com/mqxs/p/7380933.html

(1)SUBSTRING_INDEX的写法

SELECT SUBSTRING_INDEX(profile,",",-1) gender,COUNT(*) number
FROM user_submit 
GROUP BY gender;

(2)LIKE的写法【mark一下,原来有IF(profile LIKE '%female','female','male') 这样的方式】

SELECT IF(profile LIKE '%female','female','male') gender,COUNT(*) number
FROM user_submit
GROUP BY gender;