matches

Matches the columnValue with regex.

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

bytes

2973

1101

1101

1726990

166

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

Output

bytes

bytes_matches

2973

true

1101

true

1101

true

1726990

false

166

false


Did this page help you?