MySQL regexp_substr() Function

MySQL regexp_substr() function is used for pattern matching. It returns the substring from the given string.

Syntax

snippet

select regexp_substr('str', 'match_type', occurrence, position, );

snippet

select regexp_substr('java t point', '[a-z]+', 2, 3);

Output:

snippet

select regexp_substr('my sql function', '[a-z]+', 1, 3);

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 +