Consultas con regex y coincidencia de patrones

Sometimes you need to search for documents where a string field contains, starts with, or ends with a certain pattern—but you do not know the exact value. Simple equality filters like { name: 'Alice' } only match exact strings. Regular expressions (regex) give you flexible pattern matching against string fields in MongoDB.

MongoDB supports regex through the $regex operator or by passing a JavaScript regex literal directly in a query filter. Both approaches work, with slightly different syntax for setting options like case-insensitivity.

There are two ways to use regex in MongoDB queries:

• JS regex literal: { name: /alice/i } — concise, flags go after the closing slash
• $regex operator: { name: { $regex: 'alice', $options: 'i' } } — more verbose but required when combining with other operators

Both forms produce identical results. Use the JS literal syntax for simple queries; use the $regex operator form when you need to build the pattern dynamically from a string variable or combine it with other operators on the same field.

MongoDB supports four regex option flags:

• i — Case-insensitive: /alice/i matches 'Alice', 'ALICE', 'alice'
• m — Multiline: ^ and $ match the start/end of each line rather than the whole string
• s — Dot-all: . matches any character including newlines
• x — Extended: whitespace in the pattern is ignored (for readable patterns with comments)

The most commonly used flag is i. The m flag is useful for searching multi-line text fields like blog content. Multiple flags can be combined: { $options: 'im' }.

Use regex anchors to match the start or end of a string field:

• ^ anchors to the start: /^Admin/ matches strings that begin with 'Admin'
• $ anchors to the end: /\.pdf$/ matches strings ending with '.pdf'

A critical performance fact: a prefix regex with a caret (/^prefix/) CAN use a regular B-tree index on that field—MongoDB can seek directly to the prefix in the index. This makes prefix searches much faster than mid-string searches. Never use a leading wildcard (/.*pattern/ or /pattern/ without ^) on a large collection without a text index.

Regex gives you expressive pattern primitives:

• . — any character (except newline, unless s flag set)
• [abc] — character class: matches a, b, or c
• [a-z] — range: any lowercase letter
• \d — any digit (equivalent to [0-9])
• \w — any word character ([a-zA-Z0-9_])
• *, +, ? — zero or more, one or more, zero or one
• {n}, {n,m} — exactly n, between n and m occurrences

Regex queries and MongoDB's $text operator serve different purposes and have very different performance characteristics:

• Regex: matches by character pattern. Works on any string field, no special index needed (though prefix anchors use B-tree indexes). Suitable for format validation, prefix search, or pattern matching on small collections or indexed prefix queries.
• $text / text index: full-text keyword search with tokenization, stemming, and stop-word filtering. Requires a text index. Much faster for keyword search in large text fields (articles, descriptions, comments).

Never use /.*keyword.*/i on a large unindexed collection—it is a full scan and may be slow.

ReDoS (Regular Expression Denial of Service) is an attack where a malicious user crafts an input string that causes a poorly written regex to take exponential time to evaluate. If you pass user input directly into a regex without escaping, an attacker can hang your database query.

Always escape user input before using it in a regex by replacing all special regex characters (. * + ? ^ $ { } ( ) [ ] | \ ) with their escaped equivalents. Many libraries (like escape-string-regexp in Node.js) do this automatically. Additionally, prefer $text for user-facing search inputs over raw regex.

When you apply a regex to an array field, MongoDB checks whether any element of the array matches the pattern—the same containment semantics as equality queries on arrays. This lets you search through arrays of tags, categories, or any string array without a special operator.

For example, a document with tags: ['node.js', 'mongodb', 'backend'] would be returned by { tags: /^mongo/ } because 'mongodb' starts with 'mongo'. The regex is applied to each element independently.

A typical e-commerce search feature combines regex with other filters to provide a contextual, case-insensitive product search. The query matches product names that contain the search term anywhere in the string, filtered by category and in-stock status.

For small catalogs (under 50,000 products), regex search is acceptable. For larger catalogs or full-description search, Atlas Search (Lucene-based) provides superior relevance ranking, stemming, and performance.

Key rules for regex performance in MongoDB:

• Prefix with ^ (/^prefix/): Can use a B-tree index. Best performance for regex.
• Case-sensitive prefix (/^prefix/): Fully exploits index ordering.
• Case-insensitive prefix (/^prefix/i): Partially uses index but still much faster than no anchor.
• Contains without anchor (/pattern/): Full collection scan—use text index instead.
• Suffix (/pattern$/): Full collection scan or text index.

When in doubt, test with explain('executionStats') and look for IXSCAN vs COLLSCAN.

Before running a regex query on a production collection, test the pattern against sample documents to verify it matches what you intend and does not match what you do not intend. The MongoDB shell lets you test quickly with a small limit(), and JavaScript's String.prototype.test() or regex literals let you validate patterns in Node.js before embedding them in queries.

Also check performance with explain(): a regex that requires a full collection scan should be converted to a text query or have its collection size considered. For new collections, design with search requirements in mind—add text indexes from the start rather than retrofitting them.

Test your understanding of MongoDB & NoSQL Databases concepts from this lesson.

In this lesson you learned: regex queries use /pattern/flags or $regex operator for flexible string pattern matching—the most important flag is i for case-insensitivity, prefix-anchored regexes (/^prefix/) can use B-tree indexes for efficient lookups while mid-string patterns require full scans, and always escape user input before inserting it into a regex to prevent ReDoS attacks—or better yet, use the $text operator with a text index for user-facing search. Next up we move into updating documents with $set, $unset, and other update operators.