Sometimes i need to find and replace some strings in a column in MySQL so for this task MySQL uses the replace() function.
This is a string function and the base syntax is as follows.
you can pass a string to it or use the entry provided by a column.
Example of using the replace() function in MySQL
1 - Simple string replacement:
2 - String replacement using the where clause:
Note:
-the function is case sensitive, so be careful when using. As you can see bellow nothing was changes.