ValeriiVasyliev/wordpress-bulk-delete-all-images.md

Created February 1, 2022 09:26

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/ValeriiVasyliev/5d21bd4beb482f94b429bb9b89c686e2.js"></script>
Save ValeriiVasyliev/5d21bd4beb482f94b429bb9b89c686e2 to your computer and use it in GitHub Desktop.

WordPress : bulk deleter all images

Raw

    DELETE FROM `wp_posts` WHERE `post_type` = "attachment";

DELETE FROM `wp_postmeta` WHERE `meta_key` = "_wp_attached_file";

DELETE FROM `wp_postmeta` WHERE `meta_key` = "_wp_attachment_metadata";

DELETE FROM `wp_postmeta` WHERE `meta_key` = "_thumbnail_id";

UPDATE `wp_postmeta` SET `meta_value` = NULL WHERE `meta_key` = "_product_image_gallery";