How to delete wordpress pages directly in the database?

Question

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 the pages directly in the database without needing to delete 20 in 20 as wordpress allows?

Answer 1

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

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