SELECT Country, REPLACE(Country, 'States', 'Kingdom') FROM Persons; UPDATE tableName SET Country = REPLACE(Country, 'States', 'Kingdom') -- if Country = 'United States' -- After replace = 'United Kingdom'