matches

Matches find all rows in a query table that matches the regex.

Usage Details

`select *, matches(column, regex) from table`

Input

• column: column to match regex on
• regex: Regex which will be matched

Output
Returns a Boolean value that contains whether column value matches regex or not.

Example

Input
table = n1

`select byes, matches(bytes, “\\d{4}”) as bytes_matches from n1`

Output