Return to Snippet

Revision: 63054
at April 4, 2013 20:14 by rickygri

Initial Code
# First:

DELETE FROM wp_postmeta
WHERE post_id IN
FROM wp_posts
WHERE post_type = 'attachment'

# Second:

DELETE FROM wp_posts WHERE post_type = 'attachment'

Initial URL

Initial Description
Run these queries (phpMyAdmin will do) to delete all media in the library, and remove all post attachment affiliation

Initial Title
SQL query to delete all media and attachments in wordpress

Initial Tags
sql, wordpress

Initial Language