Get rows remaining X days before execution, fetch from datetime?

Question

MySQL

There is a table for orders. This table stores a lot of data, including the date of the order (DATETIME type). How is it possible to implement an SQL query that selects orders that have 1, 3, 5 ... days left until completion?

Answer 1

SELECT order FROM table_name WHERE date < 1