How to get the current date minus two years in mysql?

Question

I need to show in a query some items between the current date of the time in question and two years before.

Answer 1

Use the BETWEEN with date_sub to subtract an interval from the date reported:

SELECT * FROM table WHERE data BETWEEN NOW() AND DATE_SUB(NOW(), INTERVAL 2 YEAR);