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

bytesbytes_matches
2973true
1101true
1101true
1726990false
166false

© Devo Technology Inc. All Rights Reserved.