mysql_基于身份证号分析性别, 年龄和居住地

    IF(mod(SUBSTR(c.reciver_idcard_num,17,1),2),'man','woman') 性别,
    

    CASE WHEN c.reciver_idcard_num <>'' THEN (YEAR(CURDATE()) - SUBSTRING(c.reciver_idcard_num,7,4)) ELSE NULL END AS 年龄,
    

 CASE WHEN d.area_name IS NULL THEN 

    
                 (CASE LEFT(c.reciver_idcard_num,2) WHEN 11 THEN '北京' WHEN 12 THEN '天津' WHEN 13 THEN '河北省' WHEN 14 THEN '山西省' WHEN 15 
    
                 THEN '内蒙古自治区' WHEN 21 THEN '辽宁省'WHEN 22 THEN '吉林省' WHEN 23 THEN '黑龙江省' WHEN 31 THEN '上海' WHEN 32 THEN '江苏省' 
    
                 WHEN 33 THEN '浙江省' WHEN