Bulk delete WordPress posts with phpMyAdmin
I have over 8,000 posts generated by wp-o-matic and I want to get rid of all of them.
I want to execute this query in phpMyAdmin. I just want to make sure this is safe to run and it’s not wiping out my pages. This is the query:
DELETE FROM 'wp_posts' WHERE 'post_type' = 'post'