Link Search Menu Expand Document

MATCH

Checks whether the string matches the regular expression <pattern>, which is a RE2 regular expression. Returns 0 if it doesn’t match, or 1 if it matches.

Syntax

MATCH(<string>, '<pattern>')
Parameter Description
<string> The string used to search for a match.
<pattern> The regular expression pattern used to search <string> for a match.

Example

The example below generates 0 as a result because it found no match. It is searching a string of numbers for alphabet characters.** **

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

Returns: 0

In this second example, the MATCH expression generates a result of 1 because it found a match. It is searching for numeric digits in the string “123”.

SELECT
	MATCH('123','\\d+');

Returns: 1