Get upcoming birthdays with SQL (discarding the year)

birthday.sql

SELECT users.`firstname` AS first,
users.`lastname` AS last,
user_details.`birthday` AS birthday
FROM users
LEFT OUTER JOIN user_details ON user_details.user_id = users.id
WHERE
STR_TO_DATE(DATE_FORMAT(birthday,'%m-%d'),'%m-%d') >= STR_TO_DATE(DATE_FORMAT(now(),'%m-%d'),'%m-%d')
AND
STR_TO_DATE(DATE_FORMAT(birthday,'%m-%d'),'%m-%d') < STR_TO_DATE(DATE_FORMAT(now()+INTERVAL 7 DAY,'%m-%d'),'%m-%d');