Mysql asks age from dob

Question

My MySQL database has a date of birth stored in yyyy-mm-dd format, how can I query a database - without using php code - to show me the results of people born over x years and / or who are years old?

The table is called users, colum is called dob. I spent some time looking at the MySQL manual, but I cannot figure out exactly how to form my query.

So far I have gone on select * from users where dob..., but I don’t think that way.

Answer 1

Use the command INTERVAL.

SELECT * from users where dob >= (CURDATE() - INTERVAL 18 YEAR)

This returns all users under the age of 18.