mysql 1 hour ago
snippet in sql

mysql 1 hour ago

user996

DELETE FROM wp_posts
 WHERE post_date < DATE_SUB(NOW(), INTERVAL 1 HOUR)
   AND post_status = 'publish'