MySQLはユーザー表の最近の3日間の誕生日のユーザーレコードを検索します

select *
from users
where CAST(CONCAT(DATE_FORMAT(NOW(), '%Y'),DATE_FORMAT(Birthday,'-%m-%d'))  AS DATETIME )
between  CAST(DATE_FORMAT(NOW(), '%Y-%m-%d')  AS DATETIME )
and CAST( CONCAT(DATE_FORMAT(NOW(), '%Y'),DATE_FORMAT(DATE_ADD(CURRENT_DATE(),INTERVAL 3 DAY),'-%m-%d')) AS DATETIME )