SELECT
CASE
LENGTH( id_code )
WHEN 15 THEN
concat(concat('19',SUBSTRING( id_code, 7, 1 ) ),'0' )
WHEN 18 THEN
concat(SUBSTRING( id_code, 7, 3 ),'0' )
END AS age,
count( id_code ) as count
FROM
dxz_user_info
WHERE
(
CASE
LENGTH( id_code )
WHEN 15 THEN
'19' + SUBSTRING( id_code, 7, 1 )
WHEN 18 THEN
SUBSTRING( id_code, 7, 3 )
END
)
AND evidence_type = 1
GROUP BY
age
结果