mysql中通过身份证号计算实时年龄

SELECT
    *
FROM
    (
        SELECT
            DATE_FORMAT(substring(t.card_id, 7, 8),"%Y-%m-%d") birthday,
            YEAR (now()) - YEAR (substring(t.card_id, 7, 8)) age
        FROM
            sys_empl_basic_info t
    ) temp
		
WHERE temp.age BETWEEN 39 AND 45

substring()函数用来截取出生年月日

YEAR(now())- YEAR(substring(t.card_id,7,8))  age, 用来计算年龄