Delete all rows with timestamp older than x days March 28, 2023 by Tarik DELETE FROM on_search WHERE search_date < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 180 DAY))