How to get data one year before from database in mysql

How to get data one year before from database in mysql?

by Lalita 04-May-19

0 981

Answer: To select all records one year ago from today, First of all you have to get the current date for comparing the year.

SELECT * FROM users WHERE join_date <= DATE_SUB(NOW(),INTERVAL 1 YEAR);



Share:


Leave a Reply


Comments
    Waiting for your comments