UPDATE link in SQL

[TeckTP]

Hi,
We recently changed our forums url from www.olddomain.com to www.newsub.olddomain.com
We are using olddomain.com for more then 4 years and there are lots of posts with guide in posts with Photos IMG link to www.olddomain.com, but now we are change to www.newsub.olddomain.com and many posts have wrong IMG link.

Is there a way to replace this from entire database ?

Greet Tom

[yilmaz]

It should be if you run this in SQL query

PHP Code:


UPDATE  `text` SET  `rawtext` = REPLACE(`rawtext`, 'www.olddomain.com', 'www.newsub.olddomain.com') WHERE  `rawtext` LIKE '%www.olddomain.com%'; 


[TeckTP]

Sometings is wrong.

MySQL meldet: Dokumentation

1146 - table doesn’t exist’ error

--------------- Added [DATE]1606385697[/DATE] at [TIME]1606385697[/TIME] ---------------

OK correct:
UPDATE `vbtext` SET `rawtext...
now everything is OK.

Thank You