Document toolboxDocument toolbox

matches

Owned by Jonas Gonzalez
Nov 29, 2024
1 min read
[ 1 Usage Details ] [ 2 Example ]

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

Usage Details

LQL

`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

bytes

2973

1101

1101

1726990

166

LQL

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

Output

bytes

bytes_matches

bytes

bytes_matches

2973

true

1101

true

1101

true

1726990

false

166

false