SELECT * FROM <table_name> WHERE <date_field> BETWEEN DATE_SUB(NOW(), INTERVAL 1 YEAR) AND NOW();
Similarly, You can select records for 2 years, 3 years etc.
About Mohaideen Jamil
Am currently working as a Struts 2 Developer in a reputed IT Organisations.
I can help you with teaching Core java and Struts 2. Follow me on Facebook or Google Plus. If you like my tutorials, consider making a donation to this charity, thanks.