Update string in database

[ROQ]

Hi guys, 

I have a module that won't load it's settings due to a url that it looks at being changed. 

Can I manually change all the old url strings in the database to reflect the new url? 

If so what query can I run to do this? 

Ie, search for all "oldurl" instances and replace with "newurl" 

Edited October 28, 2023 by ROQ

[leemahoney3]

Which URL was changed? Was it part of the module?

[inthanet]

Hi,
the Sql query have to look like this:

UPDATE `mytable`
SET `columnName` = REPLACE(`columnName`, 'oldurl', 'newurl')
WHERE `columnName` LIKE '%oldurl%'

You need to replace: mytable, columnName, oldurl, newurl as needed in your case