select * from table1
where DATE_FORMAT(birthday,'%m-%d')= DATE_FORMAT(now(),'%m-%d') or
where DATE_FORMAT(birthday,'%m-%d')= DATE_FORMAT(date_add(now(), interval 1 day),'%m-%d') or
where DATE_FORMAT(birthday,'%m-%d')= DATE_FORMAT(date_add(now(), interval 2 day),'%m-%d') or
...
where DATE_FORMAT(birthday,'%m-%d')= DATE_FORMAT(date_add(now(), interval 7 day),'%m-%d')