How to find a document where either one or another field matches a value?

Question

My model was,

var userSchema = new Schema({
    first_name : String,
    last_name : String,
    ...
});

From this, I need to do search filter option. For that I am passing name params with value.

Now I want to return the document which contains first_name == name or last_name == name

How to write the query for that?

Mattias Farnemyhr · Answer 1 · 2014-09-13T15:19:41.740

7

User.findOne({
    $or: [
        {first_name: name},
        {last_name: name},
    ],
}, function(err, user) {
    ...
})

Use find if you expect there to be more than one document matching name to be equal to first_name or last_name.

edited Sep 13 '14 at 15:19

answered Sep 13 '14 at 13:30

Mattias Farnemyhr

A text index and an according search might work, too. – Markus W Mahlberg Sep 14 '14 at 21:32
Not sure if it worked for Ranjith, but this approach does work (it did for me). Watch out if need to search for multiple types (like String and ObjectId), since you'll get a Cast Error for ObjectId if you pass it a non-conforming string. – cjn Aug 17 '15 at 17:46

1 Answers1