Rename or Change Post Type Name Using SQL Statement
To rename or change a (custom) post type name, you can use the SQL statement below:
UPDATE `wp_posts` SET `post_type` = '<new post type name>' WHERE `post_type` = '<old post type name>';
To rename or change a (custom) post type name, you can use the SQL statement below:
UPDATE `wp_posts` SET `post_type` = '<new post type name>' WHERE `post_type` = '<old post type name>';