MySQL 24 hours ago code example
Example: mysql 1 hour ago
DELETE FROM wp_posts
WHERE post_date < DATE_SUB(NOW(), INTERVAL 1 HOUR)
AND post_status = 'publish'
DELETE FROM wp_posts
WHERE post_date < DATE_SUB(NOW(), INTERVAL 1 HOUR)
AND post_status = 'publish'