Javatpoint Logo
Javatpoint Logo

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

Example 1

Output:


MySQL regexp_instr Function

Example 2

Output:


MySQL regexp_instr Function




Help Others, Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA