WP-CLI Bulk delete posts from specific category

This should delete all posts in your category:

wp post delete $(wp post list --cat=your_category_ID --format=ids)

Or directly:

wp db query [<your_sql_query>]

For more info:

wp post delete --help
wp post list --help
wp db query --help

Related Posts:

  1. Optimize post insert and delete for bulk operations?
  2. Invalid Post Type error when attempting to filter and Bulk Edit posts
  3. How to remove bulk edit options
  4. How to create post in WP network using WP-CLI
  5. How To Add One Tag to Multiple Posts?
  6. How to bulk-untag multiple posts?
  7. wp-cli post create & media import issues
  8. how to bulk add one line in the first paragraph of all posts
  9. Bulk delete WordPress posts with phpMyAdmin
  10. Using wp-cli and delete everypost first image
  11. Removing all post tags except a given list
  12. SQL Bulk Move old posts by one author to another category
  13. Bulk update published posts date randomly using wp-cli?
  14. Post in bulk based on category template
  15. How to automate creating pages on a hosted wordpress from a local set of folders?
  16. How to delete all posts with dead image urls?
  17. Delete 100+ posts or media files from wordpress faster than default?
  18. Bulk posts from DRAFT Section
  19. Bulk replacing content of multiple pages/posts?
  20. Bulk Attach Or Insert Media To Post Without Opening Post Editor
  21. Keep featured content post in homepage with original order
  22. Are post ID’s reliable?
  23. Adding additional data to WP_Post object
  24. using wp_update_post on save_post
  25. How do I reorder (pop and push) items from WP_Query?
  26. How to exclude latest x posts from a paginated query?
  27. Plain-text tag list?
  28. Show Custom Taxonomy Categories, Listing of Posts, and Single Post via AJAX
  29. Keep a fluid max number of posts on site
  30. Network wide post count (WP Multisite)
  31. Have save_post write to database image meta [closed]
  32. Pagination not working on custom query
  33. Testing for post title in ‘if/else’ statement returns no content
  34. Number Unread comments/posts
  35. PHP Notice error (when on 404 page)
  36. get_previous_post not working as expected
  37. Add container div to gallery using post_gallery
  38. How can I remove posts of a certain category from homepage after a specified time period?
  39. WordPress’ visual editor messing up my (nested) lists (and other things as well)
  40. Create dropdown list post
  41. Show featured image next to post-teasers in Genesis Framework?
  42. Restrict next_post_link() to current category
  43. add_rewrite_rules for type of post
  44. Display Published Posts Count for Certain Time Period
  45. get_the_content(“more…”) returns full text
  46. How to load a post into an empty div tag anywhere across the pages?
  47. What is the filter or hook to add admin controls to posts on the front end?
  48. How to display Common posts from specific Tag & Category with Shortcode
  49. How can I get the media inside a post?
  50. How to handle broken links created by permalink/slug changes?
  51. Permission issue with custom post type – not added to menu – by plugin
  52. Get Page ID of blog homepage
  53. Order posts alphabetically: how to set order=asc in mysql query?
  54. How to order posts in an arbitrary order?
  55. Trying to alter the post_content through the_post
  56. How to rate a post from Admin Side / Manually?
  57. Images inside post title
  58. How to get ID of the page included with get_page()?
  59. save_post hook is not called when post is saved
  60. Howto show comment count by post in post?
  61. Summary of Posts by an User
  62. Check if current user has a post and that post has any term/s from a specific custom taxonomy outside the loop
  63. How to have more than one page for your posts if you have 8 posts but can store max 4 on a page
  64. How to remove “» (title of post or page)”?
  65. The loop starting at a certain ID
  66. How to restore deleted post related with deleted users
  67. Multiple Blog Pages
  68. Closest post to a date
  69. Adding if statement into the_content()
  70. Change modified date to current date when title updated automatically
  71. how to find the posts page
  72. Aligning images in the wp editor not working. How do i get this to work in custom theme?
  73. Showing Posts if non are found
  74. how to Update guid = “text”+post_name?
  75. Filtering private Posts
  76. Show items from a DB in a Post
  77. Diffrent layout for posts [duplicate]
  78. How to display related post from same category in single.php
  79. How to prevent WP from inserting empty posts
  80. Save All Post Permalink From A Specific Category into a .txt file
  81. How to Display Most View Post in the template file?
  82. display multiple posts and posts content on a single URL
  83. Using WP page password protection as defacto login
  84. get current index of post content in category page
  85. Permalink structure for two seperate blogs
  86. Show post excerpt
  87. How do I apply a wordpress function to something with no ID inside an archive page?
  88. Keep highlight on menu item with post pages
  89. Can’t get post_updated hook to work
  90. Add new post only in assigned category
  91. How to retrieve custom field values and save again as array
  92. Call image from post on index page?
  93. WP Query between posts custom fields [duplicate]
  94. Same sidebar in all posts as in the category
  95. Voting System, database connections?
  96. include other content type post ID not working
  97. Notify Author of the post if admin deletes his post and perform some function
  98. How to remove a date from wordpress post
  99. website images getting corrupt automatically
  100. Posts Page in WordPress loading bare HTML of my homepage

Leave a Comment