Hisashi Posted December 4, 2017 Share Posted December 4, 2017 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. Link to comment Share on other sites More sharing options...
bfarber Posted December 5, 2017 Share Posted December 5, 2017 Definitely make database backups first... UPDATE forums_posts SET post=REPLACE( post, 'example.com', 'example2.com' ); Link to comment Share on other sites More sharing options...
Hisashi Posted December 5, 2017 Author Share Posted December 5, 2017 @bfarber I use IP.Page > Articles Link to comment Share on other sites More sharing options...
Hisashi Posted December 6, 2017 Author Share Posted December 6, 2017 Resolved. I changed the codes: forums_posts and post for the article fields. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.