平成30/ 2018-12-10 16:42
mysql 年齢 生年月日
select ((year(current_date())-year(birthday)) - (right(current_date(),5)<right(date(birthday), 5))) as age, date(birthday) from Users order by id desc limit 0, 10;

(Thanks.)
http://dev.mysql.com/doc/refman/4.1/ja/date-calculations.html