-- 1

select us.gender,count(*) number

from

(select device_id,mid(profile,15,6) gender,blog_url from user_submit) us

group by us.gender;

*-- 2 字符串分割

SELECT SUBSTRING_INDEX(profile,',',-1) gender ,count(*)

from user_submit

group by gender;*

-- 3 like + if SELECT if(profile like '%female','female','male') gender,count(*) from user_submit group by gender;

******** 从具有分隔符（',' '-',...)的字符串中提取信息：substring_index

https://www.cnblogs.com/mqxs/p/7380933.html