How can we replace all the occurrences of a substring with another substring within a string in MySQL?

MySQL REPLACE() function can replace all the occurrences of a substring with another substring within a string.

Syntax

REPLACE(str, find_string, replace_with)

Here 

• Str is a string which have the substring.
• Find_string is a substring which is present one or more times within the strung str.
• Replace_with is a substring which will replace every time it finds find_string within str.

Example

mysql> Select REPLACE('Ram, My Name is Ram', 'Ram', 'Shyam');
+------------------------------------------------+
| REPLACE('Ram, My Name is Ram', 'Ram', 'Shyam') |
+------------------------------------------------+
| Shyam, My Name is Shyam                        |
+------------------------------------------------+
1 row in set (0.00 sec)

Chandu yadav

Published on 20-Feb-2018 11:11:41

• Related Questions & Answers
• Replace substring with another substring C++
• How to replace all occurrences of a string with another string in Python?
• How can we extract a substring from a string in MySQL?
• How to replace all occurrences of a word in a string with another word in java?
• In MySQL, how can we insert a substring at the specified position in a string?
• How can we get substring from a string in Python?
• Get the first occurrence of a substring within a string in Arduino
• Get the last occurrence of a substring within a string in Arduino
• Count occurrences of a substring recursively in Java
• How to replace all occurrences of a string in JavaScript?
• Find if a substring exists within a string in Arduino
• How can we extract a substring from the value of a column in MySQL table?
• How to check if string or a substring of string starts with substring in Python?
• Maximum Number of Occurrences of a Substring in C++
• In MySQL, how can we pad a string with another string?