--无脑 Case语句 select case when profile like "%,female%" then "female" when profile like "%,male%" then "male" end "gender", count(profile) "number" from user_submit group by gender