How to get last 2 days records from table using Mysql Query?

By Hardik Savani | July 22, 2016 | Category : PHP MySql

We may sometimes require to get few days ago records from table like last 2 days, last 3 days, last 10 days or last 15 days etc. Most of developer choose other logic but we can easily get using mysql query(using CURDATE and INTERVAL).

In this example mysql query i have one table "elements" and columns are id, title, description, created_at(timestamps) and update_at, Now we will get all records of last 2 you can fetch fields value using CURDATE and INTERVAL of mysql. In following example you can see how to select data of last two days.


SELECT * FROM `elements`

WHERE created_at >= ( CURDATE() - INTERVAL 2 DAY )

Hardik Savani
My name is Hardik Savani. I'm a full-stack developer, entrepreneur and owner of Aatman Infotech. I live in India and I love to write tutorials and tips that can help to other artisan. I am a big fan of PHP, Javascript, JQuery, Laravel, Codeigniter, VueJS, AngularJS and Bootstrap from the early stage.
Follow Me: Github Twitter
***Do you want me hire for your Project Work? Then Contact US.

We are Recommending you: