[T2DMan]

Mysql Search Replace

Updating information within mysql fields. Very useful

update table_name set table_field = replace(table_field,'replace_that','with_this');

[SaN-DeeP]

this is handy, used the same to replace our old domain name with a new name

UPDATE post SET pagetext = REPLACE(pagetext,'www.olddomain.com','www.newdomain.com')

to change content from posts

UPDATE pmtext SET message = REPLACE(message,'www.olddomain.com','www.newdomain.com')

for changing the PM text.

thanks to Brad for his help.