Replacing a word in a MySQL table

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]');
brucegustPHP DeveloperAsked:
Who is Participating?
thecrewConnect With a Mentor Commented:
Actually I'm certain, I don't know why I used a question mark. Remove those brackets!
Get rid of the square brackets?
Beverley PortlockConnect With a Mentor Commented:

UPDATE news SET main_body = REPLACE( main_body, 'Colgate', 'Texaco' )

See for more info
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.