CODE EXAMPLE FOR PHP

php mysql remove by timestamp older than a month

DELETE FROM on_search 
WHERE search_date < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 180 DAY))