解法1: case when 对 profile 字段使用 like 区分情况 select case when profile like '%,female' then 'female' when profile like '%,male' then 'male' end as gender, count(*) from user_submit group by gender 解法2:使用 SU...