How to delete wordpress pages directly in the database?

0

I'm making a clone of a wordpress site to model and generate another site.

However, the site has more than 2500 pages and I need to leave only 10 that I will use.

How can I delete pages directly in the database without having to delete 20 in 20 as wordpress allows?

    
asked by anonymous 27.05.2018 / 05:18

1 answer

0

The table where the pages are located is the same as the posts table posts or wp_posts depending on your configuration.

To exclude, just use the command delete from wp_posts where post_title like '%MEU_FILTRO%' or another similar command.

    
27.05.2018 / 16:08