Link Search Menu Expand Document

REGEXP_LIKE

This check whether a string pattern matches a regular expression string. Returns 0 if it doesn’t match, or 1 if it matches. This is a RE2 regular expression.

Syntax

REGEXP_LIKE(<string>, '<pattern>')
Parameter Description
<string> The string searched for a match using the RE2 pattern.
<pattern> The pattern used to search for a match in the <string>.

Example

SELECT REGEXP_LIKE('123','\\[a-z]') AS res;

Returns: 0

SELECT REGEXP_LIKE('123','\\d+') AS res;

Returns: 1