Home Mysql Mysql query for last 7 days and 30 days

Mysql query for last 7 days and 30 days

by therichpost
0 comment
mysql-select-query

Hello to all, welcome to therichpost.com. In this post, I will tell you Mysql query for last 7 days and 30 days. Today in my running project, I made query for getting last 7 days result and last 30 days result.

Here is the query code for last 7 days and 30 days:

where add_date BETWEEN DATE_SUB(CURDATE(),INTERVAL 7 DAY) AND CURDATE()

where add_date BETWEEN DATE_SUB(CURDATE(),INTERVAL 1 WEEk) AND CURDATE()

where add_date BETWEEN DATE_SUB(CURDATE(),INTERVAL 30 DAY) AND CURDATE()

where add_date BETWEEN DATE_SUB(CURDATE(),INTERVAL 1 MONTH) AND CURDATE()

There are so many queries in Mysql and I will let you know all. Please do comment if you any query related to this post. Thank you. Therichpost.com

You may also like

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.