As Mohit Bumb said, you can change the post type without fear. Changing the SQL entry in wp_posts
post_type
to page or post will be enough. There are a few options listed below.
Run an SQL Query to Change All Posts to Pages
UPDATE `wp_posts` SET `post_type`='page' WHERE `post_type`='post'
Note: wp_posts
could have a unique string between wp_ and _posts. Use yours.
- Open PhpMyAdmin.
- Follow your hosting providers instructions to log into PhpMyAdmin.
- Look for and click on your WordPress database in the left column. The correct database should have table names starting with "wp_".
- On the top tabs labeled "... Structure, SQL..." Click the SQL tab.
- Paste the code above and click on the "Go" button to change ALL posts in your database to pages.
Done; all posts will be pages.
Note: wp_posts
could have a unique string between wp_??????_posts
. Use yours.
Single Post Modification with PhpMyAdmin
SELECT * FROM `wp_posts` WHERE `post_type`='post' AND `post_status`!='trash'
- Follow steps 1 - 3 above.
- Paste the code above and click on the "Go" button to view all posts from your blog.
- Find the post you want to change by its
post_title
or other column you choose and select the edit button.
- Scroll down to
post_type
and change the text to page
- Press the "Go" button to change this post to a page.
Done; find your page in WP page category.
Note: wp_posts
could have a unique string between wp_??????_posts
. Use yours.
Plugin Method
You could use a plugin, such as Post Type Switcher, and perhaps remove it when done.