[RESOLVED] SQL - Selecting all records from past 30 days...

[clubbedougan]

Hello,

How do I only display records solely from the past 30 days with an SQL query, using the 'date' field in my database?

The column in the table is called 'date' and uses date type :

date date No 0000-00-00

I have tried :

DATE_SUB(CURDATE(),INTERVAL 30 DAY)

but to no avail.

[bradgrafelman]

The MySQL manual says this:

Here is an example that uses date functions. The following query selects all rows with a date_col value from within the last 30 days:

mysql> SELECT something FROM tbl_name
-> WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= date_col;

[clubbedougan]

Thankyou.

I'd missed out the end part 😉

[bradgrafelman]

Don't forget to mark this thread resolved (if it is).

[clubbedougan]

It sure is 😉