Update a column value, replacing part of a string

Question

Update a column value, replacing part of a string

I have a table with the following columns in a MySQL database

[id, url]

And the urls are like:

 //domain1.com/images/img1.jpg

I want to update all the urls to another domain

 //domain2.com/otherfolder/img1.jpg

keeping the name of the file as is.

What's the query must I run?

sql mysql

3 years ago by Kajalsi45d

3 Answers

Login / Signup to Answer the Question.

Login Signup

**akshay1995** · Answer 1 · 2021-06-22T12:34:48

akshay1995



UPDATE urls

SET url = REPLACE(url, 'domain1.com/images/', 'domain2.com/otherfolder/')

3 years ago

**sandhya6gczb** · Answer 2 · 2021-06-23T09:20:42

sandhya6gczb

Try using the REPLACE function:



mysql> SELECT REPLACE('www.mysql.com', 'w', 'Ww');

        -> 'WwWwWw.mysql.com'

3 years ago

**RoliMishra** · Answer 3 · 2021-06-30T12:31:31

RoliMishra

Try this...

update [table_name] set [field_name] = 

replace([field_name],'[string_to_find]','[string_to_replace]');

3 years ago

C TUTORIAL

C PROGRAMS

INTERVIEW TESTS

EXECUTE CODE

C++ TUTORIAL

C++ PROGRAMS

INTERVIEW TESTS

EXECUTE CODE

PYTHON TUTORIAL

PYTHON HOW TOS

INTERVIEW TESTS

EXECUTE CODE

JAVA TUTORIAL

JAVA CODE EXAMPLES

SPRING TUTORIAL

MORE IN JAVA

COMPUTER ARCHITECTURE

COMPUTER NETWORK

OPERATING SYSTEM

DBMS & SQL

PL/SQL

MongoDB

EXECUTE SQL

ANDROID DEVELOPMENT

GO LANGUAGE

LINUX

DOCKER

HTML TAGS (A to Z)

CSS REFERENCES

SASS/SCSS

KOTLIN

GAME DEVELOPMENT

PHP

GIT GUIDE

JAVASCRIPT

ADVANCED DSA

Update a column value, replacing part of a string

3 Answers

Login / Signup to Answer the Question.