MySQL databse mass find & replace...

[JohnXWA]

Hello,

I'd like to replace all instances of $header in a table in my databse, does anyone know how to do this?

Thanks!

[Xenon]

UPDATE tablename SET fieldname=REPLACE(fieldname,'$header','texttoinser t')

if you want to do it just in your templates (sounds like ;)) there is an option in your acp for that also