mysql - SQL Performing a search/replace search -

I have to find the specific columns for every occurrence of the string and change it with a different string. Column is a MySQL TEXT column I

  update TABLE_NAME set FIELD_NAME = (FIELD_NAME, 'find this string', 'instead of the string with this string');