Monday, September 24, 2012

Move data from one post type to another using SQL

There are many instances where you want to move the data from one post type to newly created post type in wordpress. For this you can use following simple SQL query.

UPDATE wp_posts SET post_type = 'new-post-type' WHERE post_type =  'post'

No comments:

Post a Comment