MySQL regexp_instr() Function

MySQL Regexp_instr() function is used for pattern matching. It returns the index value of the substring from the given string. This function returns 0 if no match is found else it returns 1.

Syntax

snippet

select regexp_instr('str', 'pattern', ['position']);

Example 1

snippet

select regexp_instr('BCA jhon', 'BCA')

Output:

Example 2

snippet

select regexp_instr('BCA jhon', 'BCA', 1)

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

http://codeamaze.com

Contents +