I'm having trouble with a query, or at leas finding the right function.
Google didn't do much help so I'll just ask it here:
I have a table filled with a lot of rows and I need to select all the rows that are less than a year old till now.
The table (called
select * from orders where order_date >= DATE_SUB(NOW(),INTERVAL 1 YEAR);