Checks whether the <expression> 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(<expression>, <pattern>)

​
Parameters

ParameterDescriptionSupported input types
<expression>The string used to search for a matchTEXT
<pattern>The regular expression pattern used to search <expression> for a matchTEXT

​
Return Types

  • Returns 0 if there are no matches between <expression> and <pattern>
  • Returns 1 if there are matches between <expression> and <pattern>

​
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 level;

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