select FLOOR(DATEDIFF(DATE_FORMAT(now(),'%Y%m%d'),substring(**表的身份证字段**,7,8))/365.25) age from**表名** WHERE **筛选条件**