Remove all external links from posts

You can do this by a SQL query, example:

UPDATE wp_posts
SET post_content = CONCAT(
    LEFT(post_content, LOCATE('<a', post_content) - 1), 
    SUBSTRING(post_content, LOCATE('</a>', post_content, LOCATE('<a', post_content) + 2) + 4))
WHERE post_content LIKE '%<a%';

Related Posts:

  1. How do I check if I linked to a post before I delete it?
  2. How to use “Add link” pop up for a WordPress widget
  3. Portable Post Links
  4. WordPress: How to get the current logged in author page URL?
  5. Keep getting same permalink with WP_Query?
  6. Is it possible to add a first and latest posts link?
  7. Get current users post URL?
  8. Navigation link to specific user page
  9. how to grab first link in post… and of course call it
  10. Load post content into div with ajax
  11. wp_list_categories link to first post of category instead of calling taxonomy template
  12. Link for the page archive for posts, like using custom post types with get_post_type_archive_link
  13. Linking to page with all posts
  14. Link button is not working while editing a post in Firefox [closed]
  15. Adding a text link under the post title in the lists of posts
  16. if I create ‘front-page.php’, then how do I link to post index?
  17. Setting up navigation links for posts (first, prev, next, last)
  18. Direct link to “New post” in specific category?
  19. Removing rel=”nofollow” from links posted in Post Content
  20. Delete post by giving its link
  21. How should I add links to other pages/posts from my post?
  22. Custom loop pagination links not working
  23. How to Next and Prevous Navigation Buttons on the end of the page with custom image Using Wp Post Navigation Plugin
  24. get_adjacent_post by language
  25. How to handle broken links created by permalink/slug changes?
  26. Is it possible to paste a link without tags and make it directly a link in a post?
  27. How to add a class to edit_post_link?
  28. Can’t get full post title if there a spaces in title
  29. Adding a user’s ID behind the tag ref link address
  30. All Posts Linking to Author Posts directly
  31. How to generate/create link automatically on every word of post in wordpress
  32. How to make Link to go on the first post
  33. Link to date_query results in WordPress
  34. Exists filter or action that change Add New Post link?
  35. Internal linking to posts permalink fail because of spaces and stripe at postname
  36. Authors’ Links on Homepage Not Going to Author Post Pages
  37. Short link to read complete post
  38. Delete all Tag Links from Posts
  39. Link from Post to Another Post Via Clicking on Words within Original Post
  40. Link to older links
  41. How to link post titles on page A to its posts on page B?
  42. How to create several Post pages
  43. Edit post & page option does not display on latest wordpress
  44. Add data attribute of post_id for Internal links
  45. Prevent the automatic URL linking added in last update
  46. WordPress 5: prevent link from displaying page title instead of URL
  47. Some custom post types did not return an object
  48. How do I remove all links from all my posts at once?
  49. Creating a link to the first post in a category
  50. Post Category link is same with Page link
  51. Post List Widget with custom posts and editing the Read More Link
  52. How to add a class to links inside posts text
  53. Featured Images link to post parent
  54. My posts section for logged in user
  55. External link not showing on post but showing on comment
  56. How to change link with broken link?
  57. Modifying the permalink href for posts with jquery
  58. Automatically add class to link based on link text
  59. Read more link not working [closed]
  60. After the local installation of an old WP website I can see the homepage but I can’t access to the articles, why?
  61. How to automatically convert a form with HTML link into post
  62. Automatically search and replace link in content (pages/posts)?
  63. How to remove category and other tags from posts page
  64. Listen to Post action
  65. How to add post count to wp_nav_menu?
  66. how to show all post in my page-grid.php template page
  67. How to add padding between posts
  68. Remove whitespace at the end of posts?
  69. Add filter-by-tag in the all posts admin console page
  70. How to load a different header based on post format?
  71. Getting current post ID in functions.php
  72. Getting content from a single *page* of a post
  73. Email Post Attachment on wp_insert_post Action
  74. Can I divide the pages into categories?
  75. Setting posts_per_page for taxonomy term template
  76. Posts gathered from WPEMatico feeds are being mixed in different languages. Polylang is used for language separation
  77. Turn On Comments On Custom Post Types in Directory Theme
  78. Shortcode and whitespace formatting problem
  79. Delete pubished and unpublished posts with wp_delete_post?
  80. How can I determine where I want to edit in the backend (server)
  81. Archive template combined with post slider and regular posts
  82. How to show a custom taxonomy in the theme?
  83. Removing all post tags except a given list
  84. How To Use Custom Tax of a Post Type
  85. How-to show last 5 posts
  86. How to let a user create a post by submitting a POST form?
  87. How to fix wordpress blog post error? Can anyone help to fix this issue?
  88. Query prints posts without specific categories
  89. Disable pagination in posts and pages
  90. wpautop filter off for pages but on for posts
  91. post categories – how to show only categories with a specific parent id
  92. Post URL duplication adds numerical value
  93. Body text disappearing in random posts
  94. Get part of a page url
  95. Add default content to post (for specific category)
  96. Displaying posts on Homepage
  97. Adding a time stamp on post view
  98. The post order is different for logged-in and non-logged-in users? [closed]
  99. Change a div background color on Post ID
  100. CSS code for “inserting a custom post divider” after each post
techhipbettruvabetnorabahisbahis forumueduseduseduedueduseduseduseduseduedu