Deleting records after 3 months or 6 months using mysql

Deleting records after 3 months

DELETE FROM yourtable WHERE regdate < (CURDATE() - INTERVAL 90 DAY)

Deleting records after 6 months

DELETE FROM yourtable WHERE regdate < (CURDATE() - INTERVAL180 DAY)