last week query in mysql?

[Anon]

Ok, i can answer the question for how to make a query for this week.. but...

how do i select all records from last week?

[[deleted]]

Q: how would you make that query for 'this' week, and if you can do that, what's stopping you from doing the same for one week earlier?

[Anon]

here is a query for this week:

SELECT * FROM ISSUES WHERE WEEK(DATE_ADDED)=WEEK(NOW())

and i figured out the query for last week:

SELECT * FROM TABLE WHERE WEEK(DATE_ADDED)=WEEK(DATE_SUB(NOW(), INTERVAL 7 DAY))