Say "Hello!"

  • This field is for validation purposes and should be left unchanged.

Delete Post Revisions


1
2
3
4
5
6
7
//CHANGE wp TO the prefix you chose FOR your DATABASE
DELETE a,b,c
FROM wp_posts a
WHERE a.post_type = 'revision'
LEFT JOIN wp_term_relationships b
ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id);

Back to Snippets Follow me on GitHub

Ashley Cameron logo
Blog