Why doesn't my embedded MongoDB regex work?

Question

When I query my database with:

{
    "metadata.text": "Hello world"
}

I get:

{
    "_id": {
        "$oid": "5a455574d93b6a44cd95b210"
    },
    "metadata": {
        "text": "Hello world"
    }
}

I want to modify the query so that it matches anything with 'world'. When I try:

{
    "metadata.text": {
        "$regex": "/world/"
    }
}

I get no matches.

How do I modify my query so that it matches any text containing 'world'?

Alex P. · Accepted Answer · 2017-12-28 21:12:55Z

1

Do this instead:

{
    "metadata.text": {
        "$regex": /world/
    }
}

Or

{
    "metadata.text": {
        "$regex": ".*world.*"
    }
}

If you know that your word is at the end then you can also do this:

{
    "metadata.text": {
        "$regex": /world$/
    }
}

Or

{
    "metadata.text": {
        "$regex": ".*world$"
    }
}

edited Dec 28, 2017 at 21:12

answered Dec 28, 2017 at 21:04

Alex P.

3,1813 gold badges28 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mary Over a year ago

I'm trying to run the query through mlab.com and I get the following: 'We encountered an error while parsing your JSON. Please check your syntax (e.g. ensure you are using double quotes around both your field names and values) and try again'

Alex P. Over a year ago

@Mary I added both ways you can write it, check out the update

Collectives™ on Stack Overflow

Why doesn't my embedded MongoDB regex work?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related