- 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 set of examples will help you understand the match string function. The first three statements are useful for declaring three string variables.
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 the i regular expression along with it (i will perform the case insensitive string search.)