I've been trying to fix up a comic blog that had imported all the archives from a blogger page. Unfortunately I didn't realize the first time that not all the comments had imported, so after reimporting, I ended up with a bunch of duplicates. I managed to delete all the posts without comments, leaving the 2nd reimported ones there (all manually unfortunately) which leaves me to my last task:
All the reimported posts have a "-2" at the end of the permalink. I've changed a few manually but I can't go erasing that last bit on 900+ posts! I already emptied the trash of the last posts, deleted .htaccess and tried regenerating permalinks but nothing! I checked on SQL but it doesn't seem that when I change something in the post_name entry it affects WordPress, or vice-versa.
I think what I need is a simple plugin that can search all the permalinks for an ending "-2" and just chop that bit off. Does anyone know if there is a command in SQL, PHP script, or plugin I can use to do this?