转自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;