SQL Archives - Page 2 of 2 - Freelance Web Developer Manchester | SEO Consultant

Delete WordPress “revisions” in bulk

If you want to tidy up your WordPress database a bit and delete unwanted revisions use this SQL query 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'...