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.

Edited December 4, 20177 yr by Hisashi

Definitely make database backups first...

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

 

@bfarber I use IP.Page > Articles

Resolved.

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

Edited December 6, 20177 yr by Hisashi