How to delete posts (pages) based on certain slug in their URLs in phpmyadmin

Question

I really need help with few of my websites which have thousands of pages.

Now, I want to be able to write a command in SQL to say,

Delete All Pages if their urls DO **NOT** conian one of these slugs ([an array of slugs])

For example..
I want to keep pages which have this part of their url […mydomain…] + "/england/gl/recruitment-agency/" + […another part of the url…]

This is one slug I want to keep, but I have about 40 of them.

Other pages which don’t contain those slugs they should be removed.

So, what is the command that will do the job for me?

I really appreciate any help or hints as my websites crashing down because of having too many pages.

Thank you in advance.

0
shireef khatab 1 month 0 Answers 10 views 0

Leave an answer