Update a column value replacing part of a string

Question

I have a table with the following columns in a MySQL database   id  url    And the urls are like      http   domain1 com images img1 jpg   I want to update all the urls to another domain   http   domain2 com otherfolder img1 jpg   keeping the name of the file as is    What s the query must I run

User · Answer

Try using the REPLACE function   mysql gt  SELECT REPLACE  www mysql com    w    Ww            - gt   WwWwWw mysql com    Note that it is case sensitive

User · Answer

Try this     update  table name  set  field name     replace  field name    string to find     string to replace

User · Answer

First  have to check  SELECT   FROM university WHERE course name LIKE    amp amp    Next  have to update  UPDATE university SET course name   REPLACE course name    amp amp     amp    WHERE id   1  Results  Engineering  amp amp Technology    Engineering  amp  Technology

User · Answer

You need the WHERE clause to replace ONLY the records that complies with the condition in the WHERE clause  as opposed to all records   You use   sign to indicate partial string  I E   LIKE        domain1 com images        means all records that BEGIN with       domain1 com images   and have anything AFTER  that s the   for      Another example   LIKE    http   domain1 com images       which means all records that contains  http   domain1 com images    in any part of the string

User · Answer

UPDATE yourtable SET url   REPLACE url   http   domain1 com images     http   domain2 com otherfolder    WHERE url LIKE   http   domain1 com images        relevant docs  http   dev mysql com doc refman 5 5 en string-functions html function replace

User · Answer

UPDATE urls SET url   REPLACE url   domain1 com images     domain2 com otherfolder

[mysql] Update a column value, replacing part of a string

Examples related to mysql

Examples related to sql