date minus 30

[nikko50]

Hi all.
How can I query currentdate minus 30 days so the below query should query records => 30 days old?

SELECT * from customers where enterDate >= 30 days?????

[Houdini]

How about trying

SELECT * FROM customers
WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) >= enterDate;

I am not sure if this what you want but the MySQL manual explains time and date arithmetic HERE