sql生日提示

根据生日的xx月xx日查找在$checkDate计算，$before日后生日的客户：

$checkDate为YYYY-MM-DD

WHERE substring(ADDDATE( '$checkDate', $before ),6,10)=substring(DATE_FORMAT(birthday,'%Y-%m-%d'),6,10)

$dates 天内生日的客户未考虑到平年、闰年：：

   $sql.=" (dayofyear( birthday )-dayofyear( '$checkDate' )
    BETWEEN 0 AND $dates
    OR dayofyear( ADDDATE( birthday, $dates ) ) - dayofyear( ADDDATE( '$checkDate', $dates ) )
    BETWEEN 0 AND $dates)";