select * from `tablename` where `yourdatefield` >=
DATE_SUB(CURDATE(), INTERVAL 30 DAY)
DATE_SUB(CURDATE(), INTERVAL 30
DAY)
DAY
No comments:
Post a Comment