How to query MongoDB with regex?

Question

humans.json

{
    "_id": "22YAE7bEXdST9MyrZ",
    "createdAt": {
        "$date": "2016-11-22T15:09:25.968Z"
    },
    "abilities": {
        "power": {
            "mana":78,
            "chakra":0
            "energy":60
        }
    },
    "emails": [
        {
            "address": "Rob6@rob.com",
            "working": false
        }
    ],
    "roles": [
        "killing":true
    ]
}

So I want to get only the emails.address with the first character in uppercase.

Do you want the documents where the email address is in uppercase or do you want only the email address field & project the email addresses with the first letter in capital? — Subhashree Pradhan, Jul 26 '18 at 11:21
@SubhashreePradhan I want to get all the documents that got an email in uppercase — LisaN, Jul 26 '18 at 11:32

Mạnh Quyết Nguyễn · Accepted Answer · 2018-07-26T11:22:28.403

0

Use can use regex like javascript:

db.humans.find({'emails.address': /^[A-Z]/})

If you have many emails in your array, but only want to returned matched email (start with upper case letter), you can use additional projection:

db.humans.find({'emails.address': /^[A-Z]/}, {emails: {$elemMatch: {'address': /^[A-Z]/}}})

edited Jul 26 '18 at 11:22

answered Jul 26 '18 at 11:14

Mạnh Quyết Nguyễn

17,677
1
23
51

Thank you sir for you comment, i tried this in mlab { 'emails.address': /^[A-Z]/ } Got a json validator error – LisaN Jul 26 '18 at 11:34
I believe you're doing something wrong. Here is my local result: [image link](https://imgur.com/a/fScTjhq) – Mạnh Quyết Nguyễn Jul 26 '18 at 11:38

How to query MongoDB with regex?

1 Answers1