How To Get Last Month Data In MySQL?

Hi Friends,

I am going to explain you example of how to get last month data in MySQL?. You will learn MySQL query to get months data. I would like MySQL select data last of month. This article will give you simple example of SQL query to get last months record.

We will use get search how to select last months data from table using MySQL. You can understand a concept of search how to take last month data from the current month in MySQL. So, we can illustrate the getting a data last months in the MySQL.

You can see both example of how do I get last months data in MySQL.

Let's see bellow example:

Table: users

Solution SQL Query:

SELECT 
    * 
FROM `users` 
WHERE DATE(created_at) >= DATE_ADD(LAST_DAY(DATE_SUB(NOW(), INTERVAL 2 MONTH)), INTERVAL 1 DAY)
   AND DATE(created_at) <= LAST_DAY(DATE_SUB(NOW(), INTERVAL 1 MONTH))

Output:

I hope it will help you...