mysql根据出生日期查询年龄

SELECT DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(birthday)), '%Y')+0 AS age FROM 表名;

 

SELECT * FROM t_expert WHERE (DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW()) - TO_DAYS(expert_birthday)), '%Y') + 0) > 10
AND (DATE_FORMAT(FROM_DAYS( TO_DAYS(NOW()) - TO_DAYS(expert_birthday) ),'%Y') + 0) < 30;