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.
Thanks,
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.
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
Note:
wp_posts
could have a unique string between wp_ and _posts. Use yours.Done; all posts will be pages.
Note:
wp_posts
could have a unique string betweenwp_??????_posts
. Use yours.Single Post Modification with PhpMyAdmin
post_title
or other column you choose and select the edit button.post_type
and change the text to pageDone; find your page in WP page category.
Note:
wp_posts
could have a unique string betweenwp_??????_posts
. Use yours.Plugin Method
You could use a plugin, such as Post Type Switcher, and perhaps remove it when done.