Jump to content

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

Featured Replies

Posted

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 by Hisashi

Definitely make database backups first...

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

 

  • Author

@bfarber I use IP.Page > Articles

  • Author

Resolved.

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

Edited by Hisashi

Archived

This topic is now archived and is closed to further replies.

Recently Browsing 0

  • No registered users viewing this page.