UPDATE tableName
SET columnName = REPLACE(
  columnName,
  'TEXT TO SEARCH FOR',
  'TEXT TO REPLACE WITH'
)