sql 通过身份证号字段 推算 年龄age与性别sex

首先是需要查出身份证号字段 
在取身份证号上的出生年月判断个人年龄
在取身份证号上尾数判断个人性别

DEMO SQL： 

SELECT
    b.idno as 身份证号,
    (year(NOW())- substring(b.idno,7,4)) as 年龄,
    case if(length(b.idno)=18, cast(substring(b.idno,17,1) as UNSIGNED)%2, if(length(b.idno)=15,cast(substring(b.idno,15,1) as UNSIGNED)%2,3))
    when 1 then '男'
    when 0 then '女'
    else '未知'
    end AS 性别
FROM
    table.name as b