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');

snippet

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

Output:

snippet

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

Output:

Related Tutorial

1 MySQL Not Like Operator

2 MySQL Not regexp Operator

3 MySQL Regexp Operator

4 MySQL regexp_instr() Function

5 MySQL regexp_like() Function

6 MySQL regexp_replace function

7 MySQL regexp_substr() Function

Try it

Contents +