advanced code snippet search

Posted By

martins42 on 04/10/12


Tagged

wordpress wp


Versions (?)

Delete WordPress post revision from DB

 / Published in: SQL
 

URL: http://lesterchan.net/wordpress/2008/07/17/how-to-turn-off-post-revision-in-wordpress-26/

Delete WordPress post revision from DB. If, eventually, you need to… (:

Expand | Embed | Plain Text 
  1. DELETE a,b,c
  2. FROM wp_posts a
  3. LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
  4. LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
  5. WHERE a.post_type = 'revision'

Report this snippet  

You need to login to post a comment.