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
You must be logged in to post a comment.
RT @CodeSnippetsNET: How to replace a string in MySQL http://t.co/qQLu5zBVZ4 #mysql #php #programming #html #js #css