Bulk changing post format

  • I’m sitting with a site here in which every single post is set to the post format “image”.

    I would like to change all of the posts to the post format “standard”.

    Having two, I would bet 1 kidney on the fact that this used to be possible on the wordpress bulk edit screen. But now it is gone.

    I have also been unable to find a plugin for this task so I guess I need to do this via SQL (I have PHPmyadmin installed).

    Can someone help me out with getting this done?
    Where do I have to look for the setting and what kind of SQL query would I need to achive this?

    Thanks in advance.

Viewing 2 replies - 1 through 2 (of 2 total)

  • You could look in or search the wp_terms table (your table prefix might be different) to identify the ID of the term with slug post-format-image. In my test case it happened to be 8.

    Then, in the wp_term_relationships table (after backing it up), delete the rows where term_taxonomy ID is the ID that you identified. I used this SQL, and it seemed to work:

    DELETE FROM wp_term_relationships WHERE term_taxonomy_id = 8

    Thread Starter deus62

    (@deus62)

    Thanks, Rod.
    I’ll give that a try.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Bulk changing post format’ is closed to new replies.