MySQL where date last 7 days

2019-09-17 16:14:32 Ranjan Mysql

MySQL query to get records of last 7 day.

In this example we will see a sample query to get last 7 days records from mysql table.


Select * from your_table where created_date >= DATE(NOW()) - INTERVAL 7 DAY

This post is submitted by one of our members. You may submit a new post here.

Related Tricks