Black Friday sale is now on! 50% off Laravel: The Modular Way. Learn more

MySQL get users birthday

David Carr

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.