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