Delete Post Revisions

by Ashley N Cameron

Published: Dec 11, 2012

SnippetsWordPress

About a 1 minute read

"The art of living… is neither careless drifting on the one hand nor fearful clinging to the past on the other. It consists in being sensitive to each moment, in regarding it as utterly new and unique, in having the mind open and wholly receptive."

Alan Watts


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