1 2 3 4 5 6 7 8 |
select * from users where ( month(date_of_birth) > month(CURDATE()) and month(date_of_birth) < month(ADDDATE(CURDATE(),30)) ) or ( month(CURDATE()) = month(date_of_birth) and day(date_of_birth) >= day(CURDATE()) or month(ADDDATE(CURDATE(),30)) = month(date_of_birth) and day(date_of_birth) <= day(ADDDATE(CURDATE(),30)) ) or ( year(CURDATE()) > year(ADDDATE(CURDATE(),30)) and month(date_of_birth) < month(CURDATE()) and month(date_of_birth) > month(ADDDATE(CURDATE(),30)) ) |
