Mongdb query multiple value in different docs

Question

How could query multiple value in one collection?

const user = db.collection('users').findOne({ username: 'john' })
const user = db.collection('users').findOne({ email: '[email protected]' })

Below are some dummy data. i hope could query name john and email docs in one line of code.

[{id:1, username: 'john', email: '[email protected]'},{id:2, username: 'kelvin', email: '[email protected]'}, {id:3, username: 'angle', email: '[email protected]'}]

Return Data Are: only id: 1 and 2. becasue they match the query

    [{id:1, username: 'john', email: '[email protected]'},{id:2, username: 'kelvin', email: '[email protected]'}]

J.F. · Accepted Answer · 2020-11-25 08:50:59Z

2

You can use $or operator in this way:

db.collection.find({
  "$or": [
    {
      "username": "john"
    },
    {
      email: "[email protected]"
    }
  ]
})

So you will find a document which matches username or email.

Exmaple here

edited Nov 25, 2020 at 8:50

answered Nov 25, 2020 at 8:35

J.F.

15.3k10 gold badges41 silver badges74 bronze badges

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

1 Comment

Wilker Over a year ago

Oh! Thanks you! It is what i look for =)

Collectives™ on Stack Overflow

Mongdb query multiple value in different docs

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related