Skip to content

Instantly share code, notes, and snippets.

@bigandy

bigandy/rename-cpt-db.sql

Last active December 18, 2015 16:49
Show Gist options
  • Save bigandy/5814387 to your computer and use it in GitHub Desktop.
Save bigandy/5814387 to your computer and use it in GitHub Desktop.
Download ZIP
Rename CPT name after have changed CPT name
Raw
rename-cpt-db.sql
SELECT * FROM DBPREFIX_posts where post_type = 'OLD_CPT'
UPDATE DBPREFIX_posts SET post_type = 'NEW_CPT' where post_type = 'OLD_CPT'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment