Getting records within the last week, starting BEFORE the current day...

[Jabop]

SELECT * FROM most_viewed WHERE Date>=DATE_SUB(CURDATE(), INTERVAL 1 WEEK) ORDER BY Views DESC LIMIT 1

 

This selects the records that are within the last week. The trouble I'm coming into is that I need to select the records within the last week, that are *before* the current day. I tried this:

 

SELECT * FROM most_viewed WHERE Date>=DATE_SUB(DATE_ADD(CURDATE(), INTERVAL -1 DAY), INTERVAL 1 WEEK) ORDER BY Views DESC LIMIT 1

 

Which did not do the trick.

 

Today is the 15th. I want to select everything from the 14th, and 7 days prior to that. How could I go about that?

[mwasif]

SELECT * FROM most_viewed WHERE Date>=DATE_SUB(DATE_ADD(CURDATE(), INTERVAL -1 DAY), INTERVAL 1 WEEK) AND Date<CURDATE() ORDER BY Views DESC LIMIT 1