Basically I have around 4000 pages on my wordpress site and I have identified 1320 are duplicates.
I know I can go select each and every one manually and then bulk move them to the trash etc but does anyone know of a more time efficient way to do this?
Perhaps a MYSQL query to delete all the duplicates pages?
An example of the urls is as follows:
/page-2/ and sometimes even /page-3/
There must be a way to mass delete all pages with the added -2 or -3
Thanks for any and all help.
Some added information
I created pages depending on locations and I've just realised that I have pages such as
Berwick upon Tweed
I'd Ideally like to delete the pages with the - in the title as well