Link Search Menu Expand Document

MATCH_ANY

The same as MATCH, but it searches for a match with one or more more regular expression patterns. It returns 0 if none of the regular expressions match and 1 if any of the patterns matches.

Synonym for MULTI_MATCH_ANY

Syntax

MATCH_ANY(<string>, <pattern_array>)
Parameter Description
<string> The string to search for a match.
<pattern_array> A series of one or more regular expression patterns to search for a match in the <string>.
<pattern_array></code> must be enclosed in brackets. Each pattern must be enclosed in single quotes and separated with commas.
For example, the <pattern_array> below consists of two regular expression patterns:
[ '\\d+', '\\[a-Z|A-Z]' ]

Example

The query below searches for any matches within the string 123 with the patterns ['\d+','\[a-Z|A-Z]']. Since at least one is found, it returns: 1

SELECT
	MATCH_ANY('123', [ '\\d+', '\\[a-Z|A-Z]' ]) AS res;

Returns: 1