MySQL query statement: display data for the last 4 weeks

Question

How to write a query in MySQL to retrieve data for the past 4 weeks starting from today. I googled the query but I only get last week's data. The week should start today and last 4 weeks. The following is my data|sales|dated|---------------------------------|12|01-08- 202221:00||34|30-07-202221:00||45|29-07-202221:00||67|28-07-202221:00|

P粉197639753 · Answer

You can use the week number as the field value for each row:

SELECT *, FLOOR(DATEDIFF(CURRENT_DATE(), dated)/7) + 1 AS week_no 
FROM sales
WHERE dated > CURRENT_DATE() - INTERVAL 4 WEEK
ORDER BY dated DESC;