Update a certain word in all entries

[eyecrave]

I need to update my entire database to reflect my new domain name. I need to change all the entries and with over 3000 entries I'd prefer not to do them one at a time.

How can I accomplish this?

[chazzy]

http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_replace

something like this probably..


UPDATE table SET column = REPLACE(column,'old domain','new domain');