celticwebdesign · December 29, 2016 14:32
diff --git a/SQL query to delete all media and attachments in wordpress b/SQL query to delete all media and attachments in wordpress
 http://snipplr.com/view.php?codeview&id=70656

 # First:

 DELETE FROM wp_postmeta
 WHERE post_id IN
 (
 SELECT id
 FROM wp_posts
 WHERE post_type = 'attachment'
 )
 ;

 # Second:

 DELETE FROM wp_posts WHERE post_type = 'attachment'