In this article, we will see how to get the last 15 days records in MySQL query. In PHP, you can use INTERVAL to get the last 15 days record from the database table. For MySQL queries, we use the INTERVAL operator. It is mainly used to calculate the date and time values.

So, let's see SQL query to get the last 15 days records and how to get the last 15 days data in PHP from MySQL Database.

In this example, we will see SQL query to get data for the current month in MySQL.

id | order_date | amount | Orders
---+------------+--------+-------
 1 | 2022-02-01 | 150    | 2
 2 | 2022-02-02 | 200	 | 4
 3 | 2022-03-03 | 100	 | 1
 4 | 2022-03-04 | 300	 | 5
 5 | 2022-04-05 | 200 	 | 3
 7 | 2022-04-06 | 190	 | 7

 In your table, the record needs to be like date and month.

select * from users
       where order_date > now() - INTERVAL 15 day;

In the above query, we use the now() function to get the current date, and the INTERVAL() function to get the last 15 days records.

 

 

Using the below MySQL query you can get the new users in the last 15 days.

select * from users where created_at > now() - INTERVAL 15 day;

 

---

You might also like:

• Read Also: Laravel 8 Get Last 7 Days Records
• Read Also: Laravel whereBetween Query Example
• Read Also: Laravel whereMonth and whereYear Example
• Read Also: Laravel 8 Get Last 30 Days Record From Database