Posted December 4, 20177 yr 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
December 5, 20177 yr Definitely make database backups first... UPDATE forums_posts SET post=REPLACE( post, 'example.com', 'example2.com' );
December 6, 20177 yr Author Resolved. I changed the codes: forums_posts and post for the article fields. Edited December 6, 20177 yr by Hisashi
Archived
This topic is now archived and is closed to further replies.