SELECT ( case when profile like '%,male' then 'male' when profile like '%,female' then 'female' end ) as gender, count(profile) as number from user_submit group by gender 方法二: select if (profile like '%,female', 'female', 'male') as ge...