Delete WordPress post revision from DB

Submitted by:Jhon Jhon

Date added:21 April, 2012

Category:SQL

SQL code example to delete WordPress post revision from DB

Tags: delete wordpress revision

Code Snippet:

    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'
 
 

Comments