How to replace a string in MySQL

To replace a string in MySQL you can use the following snippet.

Sample MySQL

UPDATE TABLENAME 
SET FIELDNAME = REPLACE(FIELDNAME, 'ReplaceThis', 'WithThat') 
WHERE FIELDNAME LIKE '%ReplaceThis%'

One thought on “How to replace a string in MySQL

Leave a Reply