If I have to change a number of posts to pages, does this require anything more complex that setting the post-type to page on the table wp_posts? Do any other settings need to be changed.

Is it better to use a plugin like Convert Post Types or Vice Versa instead? I have a number of posts that I like being able to categorize on a site, but I may need to change to pages in the future.


  • Do I need to be concerned with any other settings or tables? I expect I would lose my tagging, but I want to make sure there is not some other table that tracks post properties differently than page properties. – Purcell Sep 6 '11 at 14:39
  • 1
    No, you don't need to be concerned by that. You're not going to "lose" your tagging, but because WordPress doesn't recognize tags as a taxonomy assigned to posts, you won't be able to access them with out some addition code. Any post type can have a taxonomy (categories, tags), you just have to assign that taxonomy to it via codex.wordpress.org/Function_Reference/… or something similar. – chrisguitarguy Oct 4 '11 at 23:59

Yes Its Possible Just Simply Run This Query Once If You're Not Developer Then Don't to Anything Just Simply log in to your cpanel->open phpmyadmin->There is maybe one or more database you've to find which one is wordpress database (click on database and where all table names starts with "wp_" its your Wordpress Database -> and check there's few tab "browse / structure /SQL" Go to SQL Paste this Code write below and click on go you're done now.

UPDATE `wp_posts` SET `post_type`='page' WHERE `post_type`='post'

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.