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