$nin

On this page

Compatibility

Syntax

This version of the documentation is archived and no longer supported. View the current documentation to learn how to upgrade your version of MongoDB.

$nin

$nin selects the documents where:

the specified field value is not in the specified array or
the specified field does not exist.

Compatibility

You can use $nin for deployments hosted in the following environments:

MongoDB Atlas: The fully managed service for MongoDB deployments in the cloud

MongoDB Enterprise: The subscription-based, self-managed version of MongoDB
MongoDB Community: The source-available, free-to-use, and self-managed version of MongoDB

Syntax

The $nin operator has the following form:

{ field: { $nin: [ <value1>, <value2> ... <valueN> ] } }
.. include:: /includes/fact-comparison-order.rst
Consider the following query:
.. code-block:: javascript
   db.inventory.find( { qty: { $nin: [ 5, 15 ] } } )
This query will select all documents in the ``inventory`` collection
where the ``qty`` field value does **not** equal ``5`` nor
``15``. The selected documents will include those documents that do
*not* contain the ``qty`` field.
If the ``field`` holds an array, then the :query:`$nin` operator
selects the documents whose ``field`` holds an array with **no**
element equal to a value in the specified array (e.g. ``<value1>``,
``<value2>``, etc.).
Consider the following query:
.. code-block:: javascript
   db.inventory.update( { tags: { $nin: [ "appliances", "school" ] } }, { $set: { sale: false } } )
This :method:`~db.collection.update()` operation will set
the ``sale`` field value in the ``inventory`` collection where the
``tags`` field holds an array with **no** elements matching an
element in the array ``["appliances", "school"]`` or where a
document does not contain the ``tags`` field.
.. include:: /includes/extracts/nin_operators_selectivity.rst
.. seealso::
   - :method:`~db.collection.find()`
   - :method:`~db.collection.update()`
   - :update:`$set`

Back

$ne

Logical Query Operators