Between 2 dates
select latest_date, lowest_date, floor(datediff(date(latest_date), date(lowest_date)) / 365) from your_table
With current date
select birth_date, floor(datediff(date(now()), date(birth_date)) / 365) from your_table