select row from mysql where date more than 30 days
snippet in sql

select row from mysql where date more than 30 days

user504

mysql> delete from DemoTable where UserMessageSentDate < now() - interval 30 DAY;
Query OK, 3 rows affected (0.11 sec)