根据生日计算年龄

 

select (year(now())-year('19850223')-1) + 
( DATE_FORMAT('19850223', '%m%d') <= DATE_FORMAT(NOW(), '%m%d') ) as age;