Need mySQL Query help

[guerilla]

I have a table with a column that is text.

Let's assume

db name: database
table name: table
text column: column

Now I need to replace particular instance of the word monkey with donkey in this text field, but the field is loaded with a lot of text data.

What query would I use?

 

[abhorrent]

update [COLOR=Yellow]table_name [/COLOR]set [COLOR=Yellow]field_name[/COLOR] = replace([COLOR=Yellow]field_name[/COLOR],'[COLOR=Orange]monkey[/COLOR]','[COLOR=Orange]donke[/COLOR][COLOR=Orange]y[/COLOR]');

 

[chemicaljake]

hm

update table set column = replace(column,'monkey','donkey');

lol

 

[guerilla]

+rep, thanks guys. You're great!