fbpx
Pages Navigation Menu

Coding is much easier than you think

How to select Last One Month Records in MySQL?

How to select Last One Month Records in MySQL?

 
 

SELECT * FROM <table_name> WHERE <date_field> BETWEEN DATE_SUB(NOW(), INTERVAL 1 MONTH) AND NOW();
 
Similarly, You can select records for 2 months, 3 months etc.
 

About Mohaideen Jamil


I'm a Full stack developer of IT exp in J2EE, AngularJs, MicroServices, Docker, Spring (Boot, MVC, Cloud), Bluemix, DevOps. Follow me on Facebook or Google Plus. If you like my tutorials, consider making a donation to this charity, thanks.

Advertisements
%d bloggers like this: