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)) ) |
![wordpress category](https://www.codehaven.co.uk/wp-content/uploads/2018/12/wp12-1.png)