We know how to change data inside a field by using update command inside a query. Here we will try to replace part of the data without changing the entire data of the field. The SQL query we design will work like string replacement in any script we use. For this we will use replace …
Tag: SQL replace query of field data
Permanent link to this article: https://blog.openshell.in/2011/01/replace-string-in-mysql-with-one-query/