Delete all rows with timestamp older than x days

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

More Related Contents:

  1. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  2. Remove duplicate rows in MySQL
  3. How to delete from multiple tables in MySQL?
  4. MySQL DELETE FROM with subquery as condition
  5. SQL query: Delete all records from the table except latest N?
  6. Deleting rows with MySQL LEFT JOIN
  7. SQL DELETE with JOIN another table for WHERE condition
  8. Mysql delete statement with limit
  9. How do I delete all the duplicate records in a MySQL table without temp tables
  10. Delete from one table with join
  11. MySQL LIMIT on DELETE statement
  12. Deleting a row based on the max value
  13. delete rows from multiple tables
  14. Deleting millions of rows in MySQL
  15. How do I escape special characters in MySQL?
  16. Enable remote MySQL connection: ERROR 1045 (28000): Access denied for user
  17. SQL counting all rows instead of counting individual rows
  18. Remote Connections Mysql Ubuntu
  19. MySQL InnoDB not releasing disk space after deleting data rows from table
  20. In MySQL, should I quote numbers or not?
  21. Dump all tables in CSV format using ‘mysqldump’
  22. MySQL add days to a date
  23. How can I loop through all rows of a table? (MySQL)
  24. Select columns across different databases
  25. MySql update two tables at once
  26. Returning query results in predefined order
  27. Django MySQL full text search
  28. How to force MySQL to take 0 as a valid auto-increment value
  29. MySQL LIKE vs LOCATE
  30. MYSQL Select One Random record from each Category

Leave a Comment