How to get data one year before from database in mysql? 0 2793 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); ❮ Previous Next ❯ Share:
Comments
Waiting for your comments