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

"What you seek is seeking you."

Rumi


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