Ashley Cameron Design

Ashley Cameron Design

Delete Post Revisions

SnippetsWordPress

About a 1 minute read

"If you truly love nature, you will find beauty everywhere."

Vincent Van Gogh


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);