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
- Redirect after deleting post and keep track of pagination
- Limit the post for differents custom post type in the same wp_query
- Multiple Content Block
- Display Custom Post Type in Recent Posts
- Slug for standard post post_type
- How to get Custom Post ID by adding filter to child theme’s function
- How do I create an archive page for standard posts?
- Remove parent from custom post type
- WordPress if in term*
- Need help targeting a custom post type with conditional tags
- wpdb custom post_type problem
- Show the same Article Available in Other Categories
- Show custom post type filtered by category
- Display random posts, but omit the post it is on?
- Custom Path/Folder behind a custom post type
- Get related posts of child term of custom post type
- Permalink misbehaving in Custom Post Types
- Change “empty trash” button text?
- Front end access to a SQL data repository – recommended way?
- Display Only Certain Category In a Custom Page Template
- wordpress lists similar type of posts in a custom post type
- why post_class() function apply css classes to all other files?
- Auto post creation
- Convert Custom Table Data Based Plugin To Be Searchable
- Limiting the Number of User Posts to Their Own Posts
- Querying posts that don’t have a certain key value or don’t have the key
- Assign a Post to a User
- News post with multiple permalinks? When opened from different page
- How to Disable option of meta field if that option is selected for any other post in custom post type?
- Display title of all custom posts from same taxonomy term on a custom post template
- Use WP pagination functions on a custom page template
- Event Manager: Events Deleted are still in DB as published but hidden in admin
- Rewrite url post_tag for custom post type
- Multiple WordPress Sites, Same Database but Filtered Content
- Single Post (CPT) in two pages – Normal and Extended
- WordPress Author Posts Review After Every Change In The Same WordPress Post
- Display posts from another page on home page in wp-editor