MySQL get users birthday

David Carr

MySQL get users birthday

PHP & MySQL Tutorials

Here's a simple way to select all birthdays for the current date, where the date of birth is stored in a MySQL database in a DATE format, in this examples a column called 'dob' is used.

SELECT username FROM users WHERE MONTH(dob) = MONTH(NOW()) AND DAY(dob) = DAY(NOW())

This will select all users that have a date of birth matching the current month and day the year is ignored.

Laravel Modules Book by David Carr

Help support the blog so that I can continue creating new content!

Subscribe to my newsletter

Subscribe and get my books and product announcements.

© 2009 - 2022 DC Blog. All code MIT license. All rights reserved.