substr(字符串，开始索引，(结束索引))

SELECT 
    SUBSTR(profile,15) gender,
    count(*) number
from 
    user_submit
GROUP BY
    gender

substring_index(字符串，分隔符，计数)

SELECT substring_index(profile,",",-1) gender,COUNT(*) number
FROM user_submit 
GROUP BY gender;