Regex queries in MongoDB - Step-by-Step Execution

Concept Flow - Regex queries in MongoDB

Start Query

↓

Specify Collection

↓

Define Regex Pattern

↓

Run Query with Regex

↓

Match Documents Found?

No→Return Empty Result

Yes↓

Return Matched Documents

↓

End Query

The query starts by selecting a collection, then defines a regex pattern to search text fields. It runs the query, checks if documents match, and returns those matches or an empty result.

Execution Sample

MongoDB

db.users.find({name: {$regex: '^A', $options: 'i'}})

Finds all users whose name starts with 'A', case-insensitive.

Execution Table

Step	Action	Regex Pattern	Document Checked	Match Result	Output
1	Start query on 'users' collection	^A	N/A	N/A	No output yet
2	Check document 1: {name: 'Alice'}	^A	{name: 'Alice'}	Matches	Include document 1
3	Check document 2: {name: 'bob'}	^A	{name: 'bob'}	No match	Exclude document 2
4	Check document 3: {name: 'anna'}	^A	{name: 'anna'}	Matches (case-insensitive)	Include document 3
5	Check document 4: {name: 'Mark'}	^A	{name: 'Mark'}	No match	Exclude document 4
6	All documents checked	^A	N/A	N/A	Return matched documents: 1 and 3

💡 All documents checked; query returns documents matching regex '^A' case-insensitive.

Variable Tracker

Variable	Start	After Doc 1	After Doc 2	After Doc 3	After Doc 4	Final
matchedDocuments	[]	[{name: 'Alice'}]	[{name: 'Alice'}]	[{name: 'Alice'}, {name: 'anna'}]	[{name: 'Alice'}, {name: 'anna'}]	[{name: 'Alice'}, {name: 'anna'}]

Key Moments - 2 Insights

Why does 'anna' match the regex '^A' even though it starts with lowercase 'a'?

Because the regex uses the 'i' option for case-insensitive matching, as shown in execution_table row 4.

What happens if no documents match the regex?

The query returns an empty result set, as explained in the exit_note and the 'No match' rows in the execution_table.

Visual Quiz - 3 Questions

Look at the execution_table, which document is included after checking document 3?

A Only {name: 'Alice'}

B Only {name: 'anna'}

C Both {name: 'Alice'} and {name: 'anna'}

D No documents included yet

💡 Hint

Check the 'Output' column at step 4 in the execution_table.

At which step does the query decide to exclude {name: 'bob'}?

A Step 3

B Step 4

C Step 2

D Step 5

💡 Hint

Look at the 'Match Result' column for document 2 in the execution_table.

If the regex pattern changed to '^M', which document would be included?

A {name: 'Alice'}

B {name: 'Mark'}

C {name: 'anna'}

D No documents

💡 Hint

Refer to the 'Document Checked' and 'Match Result' columns in the execution_table.

Concept Snapshot

MongoDB regex queries use {$regex: pattern, $options: flags} inside find().
Pattern matches text fields; options like 'i' make it case-insensitive.
Query returns documents where the field matches the regex.
Example: {name: {$regex: '^A', $options: 'i'}} finds names starting with 'A' or 'a'.

Full Transcript

This visual execution shows how MongoDB regex queries work step-by-step. The query starts by selecting the 'users' collection and defining a regex pattern '^A' with the 'i' option for case-insensitive matching. Each document is checked against this pattern. Documents like {name: 'Alice'} and {name: 'anna'} match and are included in the results, while others like {name: 'bob'} and {name: 'Mark'} do not match and are excluded. The variable tracker shows how matchedDocuments grows as matching documents are found. Key moments clarify why case-insensitivity matters and what happens if no matches occur. The quiz tests understanding of which documents match and when exclusions happen. This helps beginners see exactly how regex queries filter documents in MongoDB.