I am going to explain you example of how to get last 7 days data in MySQL?. You will learn get last 7 days data MySQL. I would like to how to get last 7 days data SQL query.
This article will give you simple example of how to get last 7 days record in MySQL. We will use how to get last 7 days data from a table in MySQL.
We will use MySQL query to get 7 days data records.
Let's see bellow example:
Table : users
Solution SQL Query:
WHERE DATE(created_at) >= (DATE(NOW()) - INTERVAL 7 DAY)
I hope it will help you...