CODEWITHSUNDEEP
mysql
Manolis
Manolis

Reputation: 57

How to do a query (limit between 2 ages - stored as date)

I have a table where it stores the users. And i want a query to find the users which are between eg 25 years old and 31 years old. The age is stored at the mysql table as date (it stores the birthday). (eg: 1980-02-25 (yyyy-mm-dd))

How the query should be written in order to find each time the people who are between two given ages?

Thanks.

Upvotes: 1

Views: 566

Answers (2)

gahooa
gahooa

Reputation: 137432

There is also the somewhat shorter BETWEEN clause for MySQL. I'd recommend CURDATE() instead of NOW() because it does not have the time component.

SELECT * FROM user
WHERE birthdate 
   BETWEEN 
   (CURDATE() - INTERVAL 31 YEAR) 
   AND 
   (CURDATE() - INTERVAL 25 YEAR)

Note: it's inclusive.

Upvotes: 0

pix0r
pix0r

Reputation: 31290

You can either compute the necessary date range in your backend code, or in MySQL itself. Should you choose MySQL, here's what the query might look like:

SELECT user.* FROM user
  WHERE birthdate >= DATE_SUB(NOW(), INTERVAL 31 YEAR) 
  AND birthdate <= DATE_SUB(NOW(), INTERVAL 25 YEAR)

Upvotes: 3

Related Questions