webCOMAND

query::where_null()

Adds an ISNULL comparison to the cQL WHERE clause. A logical AND will be used to combine it with any existing where expressions.

Prototype

where_null(mixed $expressions): query

Parameters

See where().

Return

The updated query object is returned.  This is handy for chaining additional methods.

Example

// equivalent to WHERE ISNULL(Parent)
$query->where_null('Parent');

// equivalent to WHERE ISNULL(Field1) AND ISNULL(Field2)
$query->where_null('Field1', 'Field2');

// equivalent to WHERE Age>18 AND ISNULL(Address.State)
$query->where('Age >', 18);
$query->where_null('Address.State');