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-13 _is_null Operator

SELECT JSON_SERIALIZE(data PRETTY) AS data FROM GRAPHQL('
    query {
        driver (
            check: {
                id: {_is_null: true}
            }
        ){
            id: driver_id
            name
            points
        }
    }
');

You can use the preceding 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 preceding code would not return any rows.

no rows selected