^

How to replace String in Text with SQL

Article 155 in MySQL

2021-11-30 17:22:34 from bugfish
How to replace String in Text with SQL
MySQL / Operations
Last Review on: 2022-05-23 11:04:23 | Hits: 300

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

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.
Currently 0 Upvotes!
captcha image
System - 2021-11-30 19:50:47
We appreciate comments on our site!
Theme
Switch: 188 | Arrive: 273
This Website is using Session Cookies for Site Functionality and AWStats.