Batch Clearing Contents of Posts

  • ZachMatthews

    (@zachmatthews)


    12 years ago

    I migrated from a Pixelpost install to a WP photoblog using the Snapcase theme. Snapcase makes use of the Featured Image tool to set the photo for each individual post.

    When I did the migration (1500 images = 1500 posts by the way), my old Pixelpost install left a lot of gibberish in the posts themselves.

    I can delete the full contents of a post, BUT NOT delete the post itself or the featured image, and everything works great.

    So I am looking for a way to basically zero out the contents for each of my posts, but not actually delete the posts themselves or the featured images.

    So far all I have been doing is going into each post individually, selecting everything, deleting it, then hitting update. That is going to be unbelievably slow for 1500 images.

    Can anyone help? Is there maybe some kind of MYSQL command I can enter to wipe just one part of each post (i.e. the contents, but not the featured image)?

    Thanks,
    Zach

Viewing 1 replies (of 1 total)

  • Try this SQL Query

    UPDATE wp_posts SET post_content = '' WHERE post_type ='post'

    I don’t know if the theme create a specific post type for photos. If yes, change post for the correct post type.

    Backup your data before execute it.

Viewing 1 replies (of 1 total)
  • The topic ‘Batch Clearing Contents of Posts’ is closed to new replies.