SQL: Delete Posts that are over 'X' Days Old

5/20/2016 - 12:58 AM

DELETE FROM 'wp_posts'
WHERE 'post_type' = 'post'
AND DATEDIFF(NOW(), 'post_date') > X

Cacher is the code snippet organizer for pro developers