Update part of a string in mysql

UPDATE table
SET field = REPLACE(field, 'string', 'anothervalue')
WHERE field LIKE '%string%';

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'

Similar codes

1 vote193 views2 answers
Test sqlsrv connection
SQL
0 vote315 views3 answers
Osx stop mysql service
SQL
7 votes268 views2 answers
Oracle foreign key reference table
SQL
0 vote215 views4 answers
Convert databse to achieve log mode oracle
SQL
0 vote206 views1 answer
Sql_inner_join
SQL
1 vote212 views2 answers
One to one and one to many relationship
SQL
2 votes225 views6 answers
In operator in sql
SQL
0 vote206 views2 answers
How to see table associated with a schema in sql
SQL
0 vote199 views2 answers
How do I install microsoft SQL on my Mac?
SQL
1 vote200 views2 answers
Setval max id postgresql sequence
SQL