Where
The where
operator filters rows, returning only rows that satisfy the the provided boolean expression.
To find the events containing an email address that ends with .gov
, use the query below:
Loading APL Editor...
No query result to show, please click the 'run query' button above!
Here are a few other boolean expressions to try:
first_name == "Willard"
gender != "Male"
id < 3
ip_address matches regex "67.*"
Boolean expression can also be combined using and
and or
:
ip_address matches regex "67.*" or gender != "Male"
Try updating the query to find records last name Frediani
or an ip address containing 255
.
To learn more, see the where docs.