How To Get Last 30 Days Data In MySQL?

MySQL

Nicesnippets

29-01-2022


Hi Friends,

I am going to explain you example of how to get last 30 days data in MySQL?. You will learn MySQL query to get last 30 days data. I would like get last 30 days records in MySQL. This article will give you simple example of SQL query to get last 30 days data.

We will use get search how to select last 30 days from news table using MySQL. You can understand a concept of search how to take last 30 days dates from the current month in MySQL. So, we can illustrate the getting a date 30 days in the past MySQL.

You can see both example of how do I get my last 30 days data in MySQL.

Let's see bellow example:

Table : users


Solution SQL Query:

SELECT

*

FROM `users`

WHERE DATE(created_at) >= (DATE(NOW()) - INTERVAL 30 DAY)

Output:

I hope it will help you...