Hi. I have a very simple task of grabbing the data for the past 7 days. My current query looks like this:
select * from `table`
where `date` > CURDATE() -7
This works perfectly well, only when we get to the next month it is not grabbing any day from the previous month. I need to grab the data regardless of what month it is, just the last 7 days. I can't find the right syntax for this.
Thank you in advance!