PHP - How to select records from last 30 days MySQL

Question

I have a table with a column name "ordered_at" where I have entered the value of time(). How can I select records from the last 30 days?

Answer 1

You could use datediff to get the number of days passed between current_date and the value in the column:

SELECT *
FROM   mytable
WHERE  DATEDIFF(CURRENT_DATE, ordered_at) <= 30