Ashley Cameron Design

Ashley Cameron Design

Shop the Creative Design Market

Goodnight

SQL Query for Renaming Custom Post Types and Taxonomies

This post was last updated: Sep 3, 2020
MySQLSnippetsWordPress

About a 1 minute read

"Every great design begins with an even better story."

Lorinda Mamo, designer


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