codehaven - php snippets - coding help
Generic filters
Exact matches only
    • octopus energy discount code

    Find Birthday next 30 days MYSQL

    13th April 2017

    MySql

    mysql codehaven category

    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)) )
     

    Was this code snippet helpful?

    RSS Latest Snippets
    LINKS
    A Repository of Code Snippets in many Programming Languages:-

    PHP – JQUERY
    CSS – MYSQL
    WORDPRESS – JAVASCRIPT
    WOOCOMMERCE – HTML

    © 2022 CODEHAVEN