Database Manual / Reference / Query Language / Query Predicates

Bitwise Query Predicate Operators

Bitwise operators return data based on bit position conditions.

NameDescription

$bitsAllClear

Matches numeric or binary values in which a set of bit positions all have a value of 0.

$bitsAllSet

Matches numeric or binary values in which a set of bit positions all have a value of 1.

$bitsAnyClear

Matches numeric or binary values in which any bit from a set of bit positions has a value of 0.

$bitsAnySet

Matches numeric or binary values in which any bit from a set of bit positions has a value of 1.