Trying to find with $regex multiple fields at the same time in Mongodb

Question

I am trying to develope a searcher in my web app, i am using mongodb... so... i have a document, with this information.

{
    "_id": "458734895734",
    "name": "user",
    "ref": "1",
    "data": "fdnsfkjndjfn"
},
{
    "_id": "3332423333",
    "name": "user1",
    "ref": "2",
    "data": "dvsdvdvds"
}

i am using $regex for match the search with my app. so i have this in my server node.js.

db.users.find({ 
    name: {'$regex': query, '$options': 'i'}
}).then((users) => {
    res.json(users);
})

        // var query, is just the pattern that i send from my web

As you can see, my server is only searching in the field 'name', how can i add other field like 'ref' and search in both fields at the same time?? i've checking the documentation in mongodb but i could not find it...

Pavan Vora · Accepted Answer · 2018-08-20 14:39:58Z

31

This is because the way you wrote the query which means it should match the given regex query with all passed parameter like and(&&) operation. What you could do is make and or(||) operation with all the required fields.

Here the sample code you can try.

db.users.find({
    "$or": [
        { name: { '$regex': query, '$options': 'i' } },
        { ref: { '$regex': query, '$options': 'i' } }
    ]
}).then((users) => {
    res.json(users);
});

answered Aug 20, 2018 at 14:39

Pavan Vora

1,75416 silver badges21 bronze badges

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

2 Comments

Sergio Cano Over a year ago

perfect ! exactly, i was missing OR operator... thank you!

FabianoLothor Over a year ago

@pavan-vora I'm with a similar problem, but in my case name and ref could be anything. Is it possible to handle that?

Dee · Accepted Answer · 2021-03-31 15:57:44Z

-2

The OR operator, regex or options doesn't need to be in quotes. Below works for me:

db.users.find({
$or: [
    { name: { $regex: query, $options: 'i' } },
    { ref: { $regex: query, $options: 'i' } }
]
}).then((users) => {
    res.json(users); 
});

answered Mar 31, 2021 at 15:57

Dee

6021 gold badge4 silver badges3 bronze badges

Collectives™ on Stack Overflow

Trying to find with $regex multiple fields at the same time in Mongodb

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related