JSON logical operators

The $and, $or, $not, and $nor logical operators are supported.

$and

The following example uses the $and operator:

{"$and":[{"age":5},{"name":"Joe"}]}

You can imply the $and operator by using a comma. The following version of the previous example uses this alternative syntax for the $and operator:

{"name":"Joe","age":5}

$not

The following example uses the $not operator:

{"$not":{"age":4}}

$or

The following example uses the $or operator:

{"$or":[{"age":4},{"name":"Joe"}]}

$nor

The following example uses the $nor operator:

{"$nor":[{"age":3},{"name":"Moe"}]}