Querying firstname and surname Combinations in CouchDB Using Selectors

Description:
Learn how to effectively query documents in CouchDB to find specific firstname and surname combinations like 'Max Smith' or 'Smith Max' using Mango selectors with correct regex patterns.
---
This video is based on the question https://stackoverflow.com/q/78920579/ asked by the user 'devreal' ( https://stackoverflow.com/u/6086482/ ) and on the answer https://stackoverflow.com/a/78921450/ provided by the user 'Alizain' ( https://stackoverflow.com/u/27055085/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: query firstname and surname in couchdb

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/licensing
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/by-sa/4.0/ ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/by-sa/4.0/ ) license.

If anything seems off to you, please feel free to drop me a comment under this video.
---
Problem Overview

When working with CouchDB documents that store firstname and surname as separate fields, you may want to query whether a particular combination exists — for example, either "Max Smith" or "Smith Max".

A naive approach using $regex with combined patterns like max|smith will not yield the desired results, as this matches either max or smith anywhere in the field, without considering the pairing or order.

Understanding the Correct Selector Pattern

To accurately query for either of the two full name combinations, you must leverage CouchDB's Mango query selectors with logical operators $or and $and:

Use $or to handle alternative acceptable name orders.

Use $and to ensure both the firstname and surname fields match the desired parts.

Use precise regex anchors (^ and $) and case-insensitive flag (?i) to match whole fields exactly.

Corrected Query Example

[[See Video to Reveal this Text or Code Snippet]]

Explanation:

^(?i)max$ matches exactly "max" ignoring case.

Two $and clauses ensure one for each name's expected field.

The outer $or statement covers both possible name orders.

Why Other Approaches Fail

Using a single regex like max|smith on each field matches either substring anywhere in the field, ignoring pairing.

Using $and with $regex on each field separately but without $or cannot differentiate the order and thus may give false positives.

Summary & Best Practices

Always use explicit logical operators ($or, $and) to combine conditions with precise intent.

Anchor regex with ^ and $ when matching exact values.

Use case-insensitive flag (?i) in regex within Mango selectors for flexible matching.

Validate field names to exactly match your document schema.

By applying the approach above, you can reliably query CouchDB to find if "Max Smith" or "Smith Max" exist as firstname and surname combinations.