Ashley Cameron Design

Ashley Cameron Design

Delete Post Revisions

SnippetsWordPress

About a 1 minute read

"The passion that we seek is within every experience; we just have to find it."

Ashley N Cameron


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