Bulk-change Post slugs which have a suffix

First thing I would backup and restore the site on a local development environment. Then you can try use this tool on your local site: https://interconnectit.com/products/search-and-replace-for-wordpress-databases/
Make sure that when you rename you are giving them something unique otherwise you may get in trouble.

Related Posts:

  1. How to get a taxonomy term name by the slug?
  2. Is there a maximum slug length?
  3. How to check if a slug exists?
  4. Can I use a number for a post/page slug?
  5. Force post slug to be auto generated from title on save
  6. How to rewrite slug of custom post type archive page
  7. How to get full slug, including all parent pages
  8. Remove Slug from Custom Post Type
  9. Add warning to edit slug/permalink button on editor screen.
  10. How to prevent duplicate slugs for wp_insert_post?
  11. How to remove certain words from url slug
  12. How to generate slugs?
  13. {Check Theme Plugin} text domain does not match the theme’s slug
  14. Possible to create a new post and have the Title and Slug automatically use the post’s ID?
  15. Display page over category archive
  16. Convert post name into post ID
  17. WP appending -2 to the end of my slug. Where are the originals stored so I can delete them?
  18. Yoast SEO breadcrumbs: how to create a filter that uses the url slug for breadcrumb titles
  19. Function to list all post slugs for every post in my WP database?
  20. Add parent template name to body class filter when visiting subpage or single post
  21. How I Can Use The Get Value as A Slug
  22. Set taxonomy slug as taxonomy title
  23. custom slug always ends in “-2”
  24. Show all wp_get_post_terms slugs
  25. Hook on slug generator
  26. How can I automatically set a post slug based on the post title during post publish?
  27. Do post_names have to be unique?
  28. slug: should I use latin characters only?
  29. How to manage same slug posts suffix method?
  30. Make wp_list_pages print slugs instead of titles
  31. Stripping unicode characters out of slug
  32. Remove slugs of old and unused custom post type
  33. What function removes apostrophes when making a slug?
  34. WordPress not adding -2 to slugs when saving post as draft
  35. Memberpress custom fields – filtering content
  36. Duplicate category slugs from pages and posts
  37. How to show “slug” in admin column?
  38. Change post slug but keep old one
  39. Why does post-slug not get saved for drafts?
  40. Remove custom post slug and add category to custom post type
  41. WordPress Reserved Terms, any workaround?
  42. Slug Taken, Cant Find Which Page
  43. How to get a page slug in WordPress?
  44. A way to export slug as meta tag
  45. Adding language based URL structure
  46. Display Terms Comma separated and Hyperlinked
  47. Is it possible to create slug on homepage and how?
  48. what to do when a Theme uses a custom post type slug that conflicts with a plugin?
  49. Wrong slug on blog page
  50. Can’t remove slug in url
  51. Set a custom post type’s title and slug to match the current date
  52. One Page or Post, n Slugs
  53. add slug of child(ren) to li using wp_list_pages
  54. Category Slugs = 404s?
  55. How to prevent post_name from incrementing in wp_insert_post?
  56. How can I get wordpress slug without certain phrase? [closed]
  57. Check for the existence of term slug
  58. How to ignore GET parameter that’s the same as a CPT slug?
  59. Make user’s first and last name as user slug
  60. Default post category overruling %category% setting for posts URL
  61. 404 errors problem with multilangual permalink pages
  62. Show post by slug sanitize_title
  63. Category Name and Slug field need to be the same otherwise it breaks category pages
  64. Get all terms/slugs – used, not used & in hierarchical order
  65. How to print partial URL after #? [closed]
  66. How to Disable UNICODE slug?
  67. list child pages as slug
  68. can’t change page slug
  69. How to put title slug into content when create a new post?
  70. WordPress v3.1 Has Character Encoding Issue With Title/Permalink?
  71. Ultimate get current page’s slug function
  72. How To Change Username Slug
  73. How can I make “sanitize_title” affect only one taxonomy?
  74. How to create extra SUB ARCHIVE for each page?
  75. Slug is already taken – how do I find the original item
  76. Duplicate Slugs on multilingual site (with Polylang)
  77. Post type child of another post type
  78. Remove parent slug for child pages
  79. which is the function that removes accented vowels?
  80. How to edit the slug/permalink in Gutenberg?
  81. Can’t edit Custom Post Type slug/permalink
  82. Using Blog Parent Slug on Blog Posts Only
  83. Get ID of child from child slug, while knowing parent ID
  84. Custom Post Type with two hierarchical Custom Taxonomies: strategy to generate best permalink structure
  85. Automaticly add slug to posts
  86. How to add numeric slug for child page in WordPress 5.9?
  87. pass user id in slug and get user information
  88. Child post with numeric only slug keeps redirecting to parent
  89. Site transferred to new server produces 404s
  90. Disable WordPress from changing URL slug when post is published
  91. Custom post type and multi taxonomies + customize url
  92. How to remove category name for only one category?
  93. Show code dependant on CPT & category
  94. Rewrite rule not working, but only when parameter is text
  95. How to enqueue a script on a specific URL that contains multiple parts
  96. Get category from slug list
  97. Is there a way to remove the option to modify the Slug in post.php
  98. Custom Post Type Rewrite Rule
  99. How can I retrieve the slug for a custom post type via name?
  100. Change get_author_posts_url / Author URL via filter
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)