Delete all drafts?

Question

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’
0
BlueDogRanch 1 month 0 Answers 9 views 0

Leave an answer