how to query an array of values using the $ne query in mongodb?

Question

how to query an array of values using the $ne query in mongodb?

this is the list i would like to query

const movies = [
  {
    name: 'crystal',
    showWatched: 'cars',
    number: 1,
  },
  {
    name: 'barbra',
    showWatched: 'moonlight',
    number: 2,
  },
  {
    name: 'marry',
    showWatched: 'sunshine',
    number: 3,
  },
 {
    name: 'joy',
    showWatched: 'cooking',
    number: 4,
  },
]

this below is the query i tried, i would like to get back everything not equal "crystal","marry" but instead this query below is returning everything

const findin = ["crystal","marry"]

db.getCollection('movies').find({name: {$ne: findin} })

silencedogood · Accepted Answer · 2019-10-29 16:07:34Z

2

You're close, but in this case you should use the $nin (not in array) operator rather than $ne (not equal). Like so:

db.getCollection('movies').find({name: {$nin: findin} })

You can check it out here.

edited Oct 29, 2019 at 16:07

answered Oct 29, 2019 at 15:46

silencedogood

3,3291 gold badge17 silver badges38 bronze badges

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

Collectives™ on Stack Overflow

how to query an array of values using the $ne query in mongodb?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related