SELECT name, birthday, MONTH(NOW()), DAY(birthday), DAY(NOW()), DAY(NOW())+7 FROM test WHERE MONTH(birthday) = MONTH(NOW()) AND DAY(birthday) BETWEEN DAY(NOW()) AND DAY(NOW())+7