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

2 votes107 views1 answer
How to insert string variable into sqlite database
SQL
0 vote103 views1 answer
How to insert a uniqueidentifier in sql
SQL
12 votes121 views6 answers
How to install sqlite3 in python
SQL
0 vote132 views1 answer
Sp help text in postgresql
SQL
23 votes107 views4 answers
How to show all users in mysql
SQL
0 vote104 views1 answer
Run postgresql dump to csv
SQL
8 votes102 views2 answers
Replace string value in sql
SQL
0 vote111 views1 answer
.sql File Run in PSQL
SQL
19 votes102 views2 answers
Mysql tinyint max value
SQL
0 vote106 views1 answer
Systemverilog unique constraint unique values
SQL