I found such a code to remove all links in the articles, but the code also deletes the link texts. Is there a sql query code that will remove the links without deleting the link texts?

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%';