UPDATE table
SET stringcol = REPLACE(stringcol, 'tester1', 'tester2')
WHERE stringcol LIKE '%tester1%'

UPDATE table
SET stringcol = REPLACE(stringcol, 'tester1', 'tester2')