Skip to main content

REGEXP_LIKE function

Returns true if str matches the regular expression pattern pattern. Returns false if it does not match.

Note

CeloSQL uses Java regex patterns.

Syntax

REGEXP_LIKE( str, pattern )

Arguments

  • str: A VARCHAR expression to be matched

  • pattern: A VARCHAR literal with a regular expression pattern

Returns

A BOOLEAN.

Examples

> SELECT regexp_like('VEND - 1234567 WILLY WONKA', '(\d+) WILLY WONKA');
true

> SELECT regexp_like('VEND - WILLY WONKA', '(\d+) WILLY WONKA');
false