I built a small content website a few years ago on a topic I know a lot about. I have only spent about 30 minutes updating the site since I built the website and wrote all the content a few years ago and whilst it isn’t a huge earner, it gets decent traffic and brings in about £30 a month consistently. Therefore I have decided to improve the design and add content on a regular basis through a blog.
As I logged into to create the blog page and amend the customise the blog design I noticed that all the content on the site was in posts rather than pages. Clearly when I created the website originally I never thought I’d be adding a blog in the future though I should have still added the content as pages instead of posts.
Thankfully, changing posts from pages is incredibly easy. All you have to do is run this short SQL query through PHPMyAdmin.
UPDATE wp_posts SET post_type = 'page' WHERE post_type = 'post'
As you can see from the above code, all content on WordPress is stored in one table, therefore you are simply changing the type of content from a post to a page. As you would expect, you can change content from pages to post in much the same way.
UPDATE wp_posts SET post_type = 'post' WHERE post_type = 'page'
The main limitation from using the above SQL command is that all pages would be converted into posts but would not have a category attached to them i.e. the post would be uncategorised.
If the thought of using PHPMyAdmin scares you a little then I recommend using the pTypeConverter plugin from Brian D Goad, which can be downloaded from Brians website or the official WordPress plugin directory.
The plugin will let you change posts to pages and vice versa at the click of a button. It is WordPress 3.0 ready too so allows you to change posts into pages, attachments, revisions and navigation items. If you are looking to quickly change all your posts into pages, I would still personally recommend using the quick SQL command via PHPMyAdmin to save time.
I hope you have found this article useful. Please leave a comment if you are unsure of anything :)