SELECT 
        CASE
            WHEN profile LIKE "%,male" THEN "male"
            WHEN profile LIKE "%,female" THEN "female"
        END AS gender,
        COUNT(*) AS number
FROM user_submit
GROUP BY gender;

《慢工出粗活》