IS NULL QBE Operator
Learn to use the _is_null
QBE operator to filter specific
data from the car racing dataset through simple examples.
Example 3-8 _is_null
Operator
SELECT JSON_SERIALIZE(data PRETTY) AS data FROM GRAPHQL('
driver (
check: {
id: {_is_null: TRUE}
}
){
id: driver_id
name
points
}
');
You can use the above code to check if there are any entries in the
driver
table where the id
field empty. The
_is_null
operator checks if the id
field is empty
and returns the corresponding details. Since the car racing example does not contain an
empty id
field, the above code would not return any rows.