I want to select data from my databse where date + 7 has to be shown

Hello,

I want to select data from my databse where date + 7 has to be shown, if date + 7 days is passed current day(real world) it should not show..

This is my code for now but I’m not sure it does what I need.

sqlQuery = “SELECT * FROM placed_orders WHERE delivery_date BETWEEN DATE_SUB(CURDATE(),INTERVAL 7 DAY) AND CURDATE() OR delivery_date=’1989-01-01′ GROUP BY ob_no ORDER BY order_date DESC”

Thanks in advance !