Ashley Cameron Design

Ashley Cameron Design

Shop the Creative Design Market

Creative Market
Home Snippets MySQL SQL Query for Renaming Custom Post Types and Taxonomies
Good afternoon

SQL Query for Renaming Custom Post Types and Taxonomies

Ashley Cameron

Published: Aug 23, 2017

This post was last updated: Sep 3, 2020
MySQLSnippetsWordPress

About a 1 minute read

"The art of living… is neither careless drifting on the one hand nor fearful clinging to the past on the other. It consists in being sensitive to each moment, in regarding it as utterly new and unique, in having the mind open and wholly receptive."

Alan Watts



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

Related Posts