jlittlejohn
5/20/2016 - 12:58 AM

SQL: Identify Any Posts that are over 'X' Days Old

SQL: Identify Any Posts that are over 'X' Days Old

new_gist_file.sql
content_copyfile_download
SELECT * FROM 'wp_posts'
WHERE 'post_type' = 'post'
AND DATEDIFF(NOW(), 'post_date') > X