WordPress.org

Support

Support » How-To and Troubleshooting » [Resolved] Delete all posts from a category

[Resolved] Delete all posts from a category

Viewing 3 replies - 1 through 3 (of 3 total)
  • Christine Rondeau

    @crondeau

    Volunteer Forum Moderator

    You should check out the bulk delete plugin.
    http://wordpress.org/extend/plugins/bulk-delete/

    Thanks, but not for 3800 posts, it only hangs each time.

    If someone else needs something like this use this query in your database.

    delete a,b,c,d
    FROM wp_posts a
    LEFT JOIN wp_term_relationships b ON ( a.ID = b.object_id )
    LEFT JOIN wp_postmeta c ON ( a.ID = c.post_id )
    LEFT JOIN wp_term_taxonomy d ON ( d.term_taxonomy_id = b.term_taxonomy_id )
    LEFT JOIN wp_terms e ON ( e.term_id = d.term_id )
    WHERE e.term_id =36

    Change 36 to you category ID number.

    Christine Rondeau

    @crondeau

    Volunteer Forum Moderator

    Oooo thanks for sharing that mysql query that’s a good one to know.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘[Resolved] Delete all posts from a category’ is closed to new replies.
Skip to toolbar