MySQL Find/Delete WordPress Post Type

Sometimes you just need to dump all the data from a post type and start over. Sometimes you need to do a little housekeeping on the db for data you no longer need/use.

 

MySQL query

Use with caution. Always backup your database first. Replace ‘product’ with your post type name.


SELECT * FROM `wp_posts` WHERE `post_type` LIKE 'product' ORDER BY `post_type` ASC
DELETE FROM `wp_posts` WHERE `post_type` LIKE 'product'