Update substring in mysql

update substring in mysql SELECT Country, REPLACE(Country, ‘States’, ‘Kingdom’) FROM Persons; UPDATE tableName SET Country = REPLACE(Country, ‘States’, ‘Kingdom’) — if Country = ‘United States’ — After replace = ‘United Kingdom’