图片说明
转自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;