Replacing a word in a MySQL table
Posted on 2011-02-17
I've got a table in a MySQL database and I need to replace a word in one particular column. I'm using the code below and it didn't work. What am I missing?
update [news] set [main_body] = replace([main_body],'[Colgate]','[Texaco]');