So vielleicht?
Code:
SELECT * FROM `table` WHERE TO_DAYS(NOW()) - TO_DAYS(`date`) - 5 < 5 AND TO_DAYS(NOW()) - TO_DAYS(`date`) - 5 > 0