SELECT (CASE WHEN CHAR_LENGTH(profile)=18 THEN 'male' ELSE 'female' END) AS gender,COUNT(*) number FROM user_submit GROUP BY gender;#这个方法不是很保险，前提前面字符个数都相等