Skip to content

Instantly share code, notes, and snippets.

@CapWebSolutions

CapWebSolutions/MySQL inquiry to find all additional post type in db

Created December 21, 2017 20:32
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save CapWebSolutions/ff322da93784c2f847f20b2dee68d6cc to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save CapWebSolutions/ff322da93784c2f847f20b2dee68d6cc to your computer and use it in GitHub Desktop.
Download ZIP
Use this gist in phpmyadmin to find extraneous stuff in db. Use Custom Post Type Cleanup PI to get rid of the stuff.
Raw
MySQL inquiry to find all additional post type in db
SELECT `ID`, `post_title`, `post_type`
FROM `wp_posts`
WHERE `post_type` NOT IN ('post','page','attachment','revision','nav_menu_item','custom_css','customize_changeset')
LIMIT 100
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment