July 8

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.

Copyright 2021. All rights reserved.

Posted July 8, 2016 by Timothy Conrad in category "Websites

About the Author

If I were to describe myself with one word it would be, creative. I am interested in almost everything which keeps me rather busy. Here you will find some of my technical musings. Securely email me using - PGP: 4CB8 91EB 0C0A A530 3BE9 6D76 B076 96F1 6135 0A1B