Select Code to Download

mysql> SELECT something FROM tbl_name
           WHERE TO_DAYS(NOW()) - TO_DAYS(date_col) <= 30;

mysql> DELETE FROM tbl_name 
           WHERE TO_DAYS(NOW()) - TO_DAYS(date_col) > 31;