What Is The Optimal Way To Select Rows From Last 7 Days?

Question

What's the best way to select only those rows from the table that have been created in last 7 days?

There are dozens of time and date functions in MySQL and I'm a little bit confused about what's the easiest way to do this.

For the sake of this question, assume that you have a table called "my_table" and it contains a row "created_at" which is a DATETIME.

SELECT * FROM my_table WHERE ...

What would you fill in the WHERE clause?

Answer 1

WHERE DATEDIFF(NOW(), created_at) <= 7;

I like it because it reads: "Where the Difference in Date between Now and when it was created is at most 7 (days)." in my own head