php mysql remove by timestamp older than a month code example

Example: php mysql remove by timestamp older than a month

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