Go to ...

Techpository

A Better Technical Repository

RSS Feed

WordPress: How to change pages to posts


There are a few ways to do this, but if you are like me and you want to do it in bulk,  a great way to do this is by using a simple SQL query.

If using phpMyAdmin

  1. Select your database
  2. Select the SQL tab
  3. type: UPDATE wp_posts SET post_type = REPLACE( post_type, “page”, “post” );
  4. Click Go

Thanks to neilscott for posting this query on the WP support forums.