Delete all drafts?

This is a common query to delete all post revisions:

DELETE a,b,c
FROM wp_posts a
LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
WHERE a.post_type = ‘revision’

Will this work to delete all drafts?

DELETE a,b,c
FROM wp_posts a
LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
WHERE a.post_type = ‘draft’

and is it better than this since it also deletes postmeta?

DELETE FROM posts WHERE post_status = ‘draft’

Read more here:: Delete all drafts?

Leave a Reply

Your email address will not be published. Required fields are marked *