Ashley Cameron Design

Ashley Cameron Design

Shop the Creative Design Market

Good morning

SQL Query for Renaming Custom Post Types and Taxonomies

This post was last updated: Sep 3, 2020
MySQLSnippetsWordPress

About a 1 minute read

"Design is not just what it looks like and feels like. Design is how it works."

Steve Jobs


1
2
3
4
5
//SQL query for renaming the posts
UPDATE `wp_posts` SET `post_type` = '<new post type>' WHERE `post_type` = '<old post type>';

//SQL query for renaming the taxonomy
UPDATE `wp_term_taxonomy` SET `taxonomy` = '<new taxonomy>' WHERE `taxonomy` = '<old taxonomy>';

*Save permalink structure in admin after running SQL Query