Mongodb-mongodb CRUD Operations, query Documents, query for Null or Missing fields

Different query operators in MongoDB treat null values differently.

The examples on this page with the Db.collection.find () method in the MONGO shell. To populate the users collection referenced in the examples, run the following in MONGO Shell:

Db.users.insert (   [      {"_id":, "name": null},      {"_id": 901}   ])

Equality Filter

The {name:null} query matches documents, either contain the name field whose value is null or that does not contain the name field.

Given the following query:

Db.users.find ({name:null})

The query returns both documents:

{"_id": +, "name": null} {"_id": 901}

If the query uses an index of sparse, however, then the query would only match null values, not missing field S.

Changed in version 2.6: If using the sparse index results in an incomplete result, MongoDB would not use the index unless a hint () Explici tly Specifies the index. See Sparse Indexes for more information.

Type Check

The {name: {$type: ten}} query matches documents that contains the name field whose value is nul l only; i.e. the value of the item field is of BSON Type Null (i.e) :

Db.users.find ({name: {$type: 10}})

The query returns only the document where the item field has a null value:

{"_id": +, "name": null}

Existence Check

the {name: {$exists: false}} query matches documents that does not contain the item field:

Db.users.find ({name: {$exists: false}})

The query returns only the document, does not contain the item field:

{"_id": 901}

See ALSO: The reference documentation for the $type and $exists operators.

Mongodb-mongodb CRUD Operations, query Documents, query for Null or Missing fields