Is there a query to replace...

[DrkFusion]

I would like to know a mysql query that will replace every instance of X with Y.

Ex: Every instances of showthread.php is to be replaced with showpoo.php or something :)

Thanks in advance
-Arunan

[FWC]

Firefly posted this one a while ago. I have used it and it worked for me:

UPDATE table SET column = REPLACE(column, 'oldvalue', 'newvalue');

[DrkFusion]

Thank FWC,

-Arunan

[DrkFusion]

How would I update the whole databae, and repalce every instance of 'oldvalue' with 'newvalue' ?

-Arunan

[Link14716]

Couldn't you just do....

UPDATE * SET column = REPLACE(column, 'oldvalue', 'newvalue');

???

[DrkFusion]

Possibly not sure, no harm in trying, so I will check it out.

Thanks
-Arunan

[Xenon]

you know this one?
http://www.vbulletin.org/hacks/index.php?s=&action=showhack&hackid=709