Replace string with mysql

Question

I have a site with a domain "mydomainA.com". I moved to a site "mydomainB.com". The problem: I have a lot of images in the pages that link to "mydomainA.com". I would like to save time and find a MySQL query that replaces all occurrences of a term ... by another to replace all occurrences of "mydomainA" by "mydomainB".

But is that really possible?

Otherwise, I would use php preg_replace edn.

Sincerely,

piotrm · Accepted Answer · 2012-01-23 09:16:19Z

2

UPDATE links SET url = REPLACE( url, 'mydomainA.com', 'mydomainB.com' )

http://dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_replace

answered Jan 23, 2012 at 9:16

piotrm

12.4k5 gold badges33 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Raphaël · Accepted Answer · 2012-01-23 10:51:03Z

1

Syntax of replace is

UPDATE table1 SET field1 = REPLACE(field1,'value1','value2')
WHERE field1 LIKE '%value1%'

Check replace function here.

Here is an example

edited Jan 23, 2012 at 10:51

Raphaël

1,1354 gold badges18 silver badges32 bronze badges

answered Jan 23, 2012 at 9:15

Sharique

4,2296 gold badges38 silver badges54 bronze badges

1 Comment

Raphaël Over a year ago

Thank you. With your example link, I can see the power of replace function.

Dario · Accepted Answer · 2012-01-23 12:45:11Z

1

Probably you are looking for the Replace MySQL command. Combined with an UPDATE just does its job.

edited Jan 23, 2012 at 12:45

answered Jan 23, 2012 at 9:11

Dario

5,3331 gold badge25 silver badges27 bronze badges

Collectives™ on Stack Overflow

Replace string with mysql

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related