[RESOLVED] find users of certain age based on birthday

[david8787]

I'm tring to find all the users in a table where their age is between 18-25 inclusive. The problem is that age is not stored in the database but their birthday is.

The best I could come up with is subtract 19 years from the current year and use to current month and day as the lower bound birthday.

Can anyone see a problem with this. Is there an easier way?

[NogDog]

Assuming MySQL, you could do something like:

SELECT * FROM users
WHERE
   DATE_SUB(NOW() INTERVAL 18 YEAR) >= birth_date AND
   DATE_SUB(NOW() INTERVAL 26 YEAR) < birth_date 

This assumes you want between the ages of 18 - 25 inclusive, thus the "INTERVAL 26 YEAR <" in the last line.

[webdevnoob]

david8787;10957205 wrote:

I'm tring to find all the users in a table where their age is between 18-25 inclusive. The problem is that age is not stored in the database but their birthday is.

The best I could come up with is subtract 19 years from the current year and use to current month and day as the lower bound birthday.

Can anyone see a problem with this. Is there an easier way?

Howdy David,

Could you post your database sql structure for that particular table?

[david8787]

Awesome, thanks for help, that will save me a lot of time.