MySQL regexp_replace function

MySQL regexp_replace() function is used for pattern matching. It replaces the given string character by matching the characters.

Syntax

snippet
select regexp_replace('str', 'character', 'new_character');

Example 1

snippet
Select regexp_replace('BCA', 'B', 'M');

Output:

MySQL regexp_replace Operator

Example 2

snippet
Select regexp_replace('Java', 'Java', 'Mysql');

Output:

MySQL regexp_replace Operator
Related Tutorial
Follow Us
https://www.facebook.com/Rookie-Nerd-638990322793530 https://twitter.com/RookieNerdTutor https://plus.google.com/b/117136517396468545840 #
Contents