Is there any way to change links from 'x' to 'y' by SQL?

[Hisashi]

Hello,

I use a link shortener that the domain was example.com, except that service lost the domain and is now called example2.com. Shortened links continue, but with another domain.

Is there any way to make this bulk change by SQL query? Otherwise, I will have to change article by article.

example.com/xxx to example2.com/xxx

------

I'm sorry for any difficulty in understanding, I don't speak english.

[bfarber]

Definitely make database backups first...

UPDATE forums_posts SET post=REPLACE( post, 'example.com', 'example2.com' );

 

[Hisashi]

@bfarber I use IP.Page > Articles

[Hisashi]

Resolved.

I changed the codes: forums_posts and post for the article fields.