/ / How to select Records between Today and Last 30 Days in MYSQL?

How to select Records between Today and Last 30 Days in MYSQL?

mySQL

SELECT * FROM <table_name> WHERE <date_field> BETWEEN DATE_SUB(NOW(), INTERVAL 30 DAY) AND NOW();

Similarly, You can select records  for 10 days , 20 days etc.
Share on Google Plus

About JK STACK

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.

2 comments:

Subscribe to: Post Comments ( Atom )