Is there a query to replace...
 

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

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

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

Thank FWC,

-Arunan

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

-Arunan

Couldn't you just do....

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

???

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

Thanks
-Arunan

you know this one?
http://www.vbulletin.org/hacks/index...ack&hackid=709