Skip to main content
Checks whether a given string matches any regular expression pattern from a specified list of patterns. Returns FALSE if it doesn’t match, or TRUE if it matches.

​
Syntax

​
Parameters

​
Return Type

BOOLEAN

​
Examples

The following code example checks whether the string 123 matches either the [a-z] expression, which specifies any lowercase letter, or the [1-9]+ expression, which specifies one or more digits:

Rows: 1Execution time: 5.37ms

The following code example checks whether the string !@#$%^&*() matches either the \d+ expression, which specifies one or more digits, or the [a-z|A-Z]+ expression, which specifies one or more lowercase or uppercase characters:

Rows: 1Execution time: 6.33ms

The following code example checks if the string a matches either the [1-9]+ expression, which specifies one or more digits, or a NULL value:

Rows: 1Execution time: 5.06ms

The following code example checks whether the string 123 matches either the [1-9]+ expression or NULL. The function returns TRUE because the string matches the first regular expression. The NULL element does not affect the result as long as a match is found.

Rows: 1Execution time: 6.09ms