Selecting everything between now and last Thursday

[guyfromfl]

Does anybody know how to do something like:

 

SELECT * FROM tbl WHERE insertDate IS BETWEEN NOW AND LAST THURSDAY

 

 

[guyfromfl]

For other inquiring minds:

 

SELECT * FROM tabl WHERE 
dateField >= CONCAT( DATE_SUB(CURDATE(), INTERVAL WEEKDAY(DATE_SUB(CURDATE(), INTERVAL 5 DAY)) DAY), ' 00:00:00');

 

Then change the interval number to whatever day of the week you want.

[gizmola]

I wrote an article about a very similar subject:  http://www.gizmola.com/blog/archives/99-Finding-Next-Monday-using-MySQL-Dates.html

[guyfromfl]

That article is AWSOME.  Perfect for what I want to do.  I just need to go backwards!  WAY cleaner than my solution.

 

Thanks a million!