Title: Bulk changing post format
Last modified: August 21, 2016

---

# Bulk changing post format

 *  [deus62](https://wordpress.org/support/users/deus62/)
 * (@deus62)
 * [12 years, 9 months ago](https://wordpress.org/support/topic/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)

 *  [Rod Whiteley](https://wordpress.org/support/users/rod-whiteley/)
 * (@rod-whiteley)
 * [12 years, 9 months ago](https://wordpress.org/support/topic/bulk-changing-post-format/#post-4084184)
 * 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](https://wordpress.org/support/users/deus62/)
 * (@deus62)
 * [12 years, 9 months ago](https://wordpress.org/support/topic/bulk-changing-post-format/#post-4084204)
 * 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.

## Tags

 * [change](https://wordpress.org/support/topic-tag/change/)
 * [post format](https://wordpress.org/support/topic-tag/post-format/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [deus62](https://wordpress.org/support/users/deus62/)
 * Last activity: [12 years, 9 months ago](https://wordpress.org/support/topic/bulk-changing-post-format/#post-4084204)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics