- String_Object: Original string to perform a search. It checks for a portion of a text present in this String_Object
- RegExp: Valid str or Regular expression you want to look. If the specified substring is not in the string_object, it will return NULL.
The following statement will search for ‘abc’ and return it. As you can see, ‘abc’ substring is repeated thrice in Str2, but the Function is returning the first occurrence.
Now, let us use i regular expression along with it (i will perform the case insensitive string search.)