select 'male' , count(sub.male) from (select SUBSTRING_INDEX(profile,',',-1) as male from user_submit) sub where sub.male = 'male' union all select 'female' , count(sub.male) from (select SUBSTRING_INDEX(profile,',',-1) as male from user_submit) sub where sub.male = 'female' 首先分析这个输出格式 得知female和ma...