How to replace String in Text with SQL
Here is an example how to replace for example the string "https://test.de/testthis/" with "https://newlink.de/testthis/".
The code is:
UPDATE tablenamehere
SET columnname = REPLACE(columnname , 'test.de', 'newlink.de');
Caution: I do not guarantee the reliability of the information given here, the code described on this page is executed at your own risk and in the event of damage or other unforeseeable consequences I am in no way responsible or liable.
