$ne for not equal in MongoDB - Step-by-Step Execution

Concept Flow - $ne for not equal

Start Query

↓

Check each document

↓

Compare field value with $ne value

↓

Include

↓

Next Document

↓

Return all included documents

↓

End

The query checks each document's field. If the field value is not equal to the $ne value, the document is included in the result. Otherwise, it is excluded.

Execution Sample

MongoDB

db.products.find({ price: { $ne: 20 } })

Find all products where the price is not equal to 20.

Execution Table

Step	Document	Field 'price' Value	Condition price != 20?	Include in Result
1	{ _id: 1, price: 15 }	15	15 != 20 is True	Yes
2	{ _id: 2, price: 20 }	20	20 != 20 is False	No
3	{ _id: 3, price: 25 }	25	25 != 20 is True	Yes
4	{ _id: 4, price: 20 }	20	20 != 20 is False	No
5	{ _id: 5, price: 30 }	30	30 != 20 is True	Yes

💡 All documents checked; only those with price not equal to 20 are included.

Variable Tracker

Variable	Start	After Doc 1	After Doc 2	After Doc 3	After Doc 4	After Doc 5	Final
Included Documents	[]	[{_id:1, price:15}]	[{_id:1, price:15}]	[{_id:1, price:15}, {_id:3, price:25}]	[{_id:1, price:15}, {_id:3, price:25}]	[{_id:1, price:15}, {_id:3, price:25}, {_id:5, price:30}]	[{_id:1, price:15}, {_id:3, price:25}, {_id:5, price:30}]

Key Moments - 2 Insights

Why are documents with price 20 excluded even though they exist in the collection?

Because $ne means 'not equal'. The condition price != 20 is false for these documents, so they are excluded as shown in execution_table rows 2 and 4.

Does $ne include documents where the field is missing?

Yes, documents missing the field are included by $ne. The condition is satisfied because the field does not exist and thus is not equal to 20. This example only shows documents with the field 'price'.

Visual Quiz - 3 Questions

Look at the execution table, which document is included at step 3?

A { _id: 4, price: 20 }

B { _id: 2, price: 20 }

C { _id: 3, price: 25 }

D { _id: 5, price: 30 }

💡 Hint

Check the 'Include in Result' column at step 3 in the execution_table.

At which step does the condition price != 20 become false for the first time?

A Step 2

B Step 1

C Step 3

D Step 5

💡 Hint

Look at the 'Condition price != 20?' column in execution_table rows.

If a document had price 20, would it be included in the final result?

A Yes, always included

B No, excluded because price equals 20

C Yes, but only if another field matches

D No, only if price is missing

💡 Hint

Refer to the meaning of $ne and the execution_table rows where price is 20.

Concept Snapshot

$ne operator in MongoDB
- Syntax: { field: { $ne: value } }
- Selects documents where field value is NOT equal to value
- Excludes documents where field equals value
- Includes documents missing the field
- Useful for filtering out specific values

Full Transcript

This visual execution shows how MongoDB's $ne operator works. The query checks each document's field value against the $ne value. If the field value is not equal, the document is included in the results. Documents with the field equal to the $ne value are excluded. The execution table traces each document's evaluation step-by-step. The variable tracker shows how the list of included documents grows. Key moments clarify common confusions about $ne behavior. The quiz tests understanding by referencing the execution visuals.