WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.


share|improve this question
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
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
up vote 2 down vote accepted

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'
share|improve this answer
I asked a similar question here, wordpress.stackexchange.com/questions/206483/… but I'm doing this in PHP. Hoping it's as simple as changing the value. – 1.21 gigawatts Oct 25 '15 at 4:03

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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