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

8 votes178 views1 answer
Racle create auto increment column
SQL
0 vote165 views1 answer
Mysql backup query
SQL
1 vote151 views1 answer
Mysql add fields
SQL
0 vote140 views1 answer
Sqlcmd no headers
SQL
8 votes138 views2 answers
Phpmyadmin default password
SQL
0 vote141 views1 answer
How to print mysql query of codeigniter query builder
SQL
27 votes179 views5 answers
Mysql set password for user
SQL
0 vote140 views1 answer
Mysql uuid
SQL
0 vote137 views1 answer
Sql compound operators
SQL
25 votes147 views5 answers
Date in mysql
SQL