Honestly, the time writing this question and waiting for an answer, is longer than just going into screen options, setting the posts to about 200, and just doing bulk move to trash, and emptying the trash – if you speed is high, you can probably do even more than 200.
else there is a nice tutorial on how and which tables you should work with here – but it will probably take longer
http://www.tripwiremagazine.com/how-to-effectively-bulk-delete-many-posts-in-wordpress/
Related Posts:
- modify all posts of a category to “no comments allowed”
- What does this PHP function code mean? [closed]
- Restrict custom post type to only site administrator role
- Linking Two Post Types
- How to force one column layout on custom post type edit page?
- Why is the »_builtin« parameter not advised in »register_post_type()« for custom post types?
- Showing current taxonomy terms
- automatically create taxonomy with same name as post title
- How do I write this SQL statement for Posts written in last 24 hours?
- Assigning a role to a specific custom post type (and ignoring other post types)
- Display posts in random post types
- Custom Post Type by user
- saving custom post type data to different table in wordpress
- Query post types with multiple keys
- [Plugin: Posts 2 Posts] Changing display order of connections
- same archive template for different custom post
- Get all posts WHERE custom_field is LIKE value
- Get the post children count of a post
- How to delete all posts from a custom post type?
- Check Title Unique Or Not and If not error message and dont save
- Remove All, Published and Trashed Post Views in Custom Post Type
- How to post twitter like updates on wordpress
- Show Two custom Post type and their posts on category page
- apply filters only to specific post listing without check the url parameters
- Custom post type and body_class: Remove “blog” class
- Is there a way to have the view link on manage posts page to open in a new window or tab?
- Display only one post each WEEK
- List custom taxonomy specific to one custom post type
- Meta query for custom post type ignored in main query
- Show titles, date of all posts on single category page
- Update postmeta Parent when post_status child change
- Allow users to create posts without logging in?
- How to sort posts in a custom post type by title in ascending order by default?
- Get_the_terms restrict output
- Custom post type menu
- YOAST SEO won’t work on custom post type archive [closed]
- Separate Content from gallery (custom post type)
- WordPress Count posts within a custom post type
- Custom post type tags not showing in search
- $wpdb is queried but results don’t show
- How set template for “custom post type” individual post
- Why doesnt my tag page populate with this custom post type?
- Why is my custom post content only viewable when signed into WordPress?
- Adding specific custom fields (images) to post excerpt
- Limit posts per page depending on the size of a div?
- Delete Post by User
- Post that populates itself (almost) automatically using data from imported excel file
- creating a custom post template
- Problem to get the link of the default ‘post’ post type like the orther custom types
- One Post with different content, depending on a Page
- Custom Post Type
- Display all post types together
- Turn post into simple slideshow
- Query multiple post of which one by taxonomy
- How to make a template for a specific post of a custom post type?
- How to delete unnecessary custom post types in the UI
- How to create a job post by email parsing? [closed]
- show posts under custom post type with same autj
- How to automate the creation of advanced layout article/post
- display posts, pages and custom post types from another wordpress site
- is therer any wordpress function to retrieve a specific html element from post content
- How to develop Knowledge center in WordPress Website
- ACF – Tags not showing up in Custom Post Types
- A developer set a ‘standard format’ for my blogposts on wordpress but i need to remove it, how?
- List Categories (wp_terms) and count posts
- Showing custom post type categories in the menu
- Display Only Certain Category In a Custom Page Template
- How to Make infinite loop of post
- WP_Query with custom post type ID
- attach CPT data to a taxonomy
- Creating separate feeds for custom post types
- Displaying multiple post types on home page
- Conflict between wp_list_pages and get_posts – list pages not displaying
- How to insert data into meta box from another plugin?
- Stores category posts in an array
- Query within a foreach within a query (queryception)
- How to implement a different permalink structure for custom post type?
- wordpress lists similar type of posts in a custom post type
- why post_class() function apply css classes to all other files?
- Update post if exist from PHP
- WordPress custom API endpoint – how to make the request more flexible
- Add to ‘action’ within post.php to allow more actions when editing a Custom Post Type in a plugin
- I can no longer post or even save a draft, getting the error “A post type mismatch has been detected.”
- Published post auto change status to pending after 90 days
- How to retrieve all wordpress posts (specific type) inside a function in php?
- Custom post type’s posts are not showing anywere but in xml sitemap
- Generate new post from email
- Auto post creation
- Batch Extract Date from post title and put into ACF custom field
- WordPress notification if new post published
- display posts of custom post type with custom taxonomy
- How to handle new post from API request?
- Creating a non-hierarchical Taxonomy that behaves like categories
- List All Custom Post Types Posts in Nav Menu Dynamically
- Only show columns in custom post type?
- Automatically update slug with latest title within custom post type [duplicate]
- Modifying the default post from wordpress
- How to Create a Separate Page for Blog Posts in WordPress
- Dynamic pages for linked categories and content
- Display custom post type for specific user