How to delete posts (pages) based on certain slug in their URLs in phpmyadmin
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])
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.