[Farcaster]

To do this in mySQL you would need to write a query something like the one below. This statement will replace all occurances of "String to be replaced" in the field with "Replacement text". To see more details on how the replace function works, go here.

UPDATE table1
SET field1 = REPLACE (field1, 'String to be replaced','Replacement text')
WHERE field1 LIKE '%String to be replaced%'

And if you want it to ignore case, use this:

UPDATE table1
SET field1 = REPLACE (LOWER(field1), 'string to be replaced','Replacement text')
WHERE field1 LIKE '%String to be replaced%'