Select age in mysql between 2 dates
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