How do I do a “NOT IN” query in Mongo?

You can use $in or $nin for “not in”

Example …

> db.people.find({ crowd : { $nin: ["cool"] }});

I put a bunch more examples here: http://learnmongo.com/posts/being-part-of-the-in-crowd/

Related Contents:

  1. Possibility of duplicate Mongo ObjectId’s being generated in two different collections?
  2. How to remove a field completely from a MongoDB document?
  3. Store images in a MongoDB database
  4. MongoDB vs. Cassandra [closed]
  5. Find duplicate records in MongoDB
  6. Best practice to maintain a mgo session
  7. How do you rename a MongoDB database?
  8. Where does mongodb stand in the CAP theorem?
  9. How to stop insertion of Duplicate documents in a mongodb collection
  10. Random record from MongoDB
  11. How to select a single field for all documents in a MongoDB collection?
  12. mongodb group values by multiple fields
  13. What’s Mongoose error Cast to ObjectId failed for value XXX at path “_id”?
  14. Mongodb $push in nested array
  15. Cascade style delete in Mongoose
  16. Multiple join conditions using the $lookup operator
  17. Add new field to every document in a MongoDB collection
  18. How to execute mongo commands through shell scripts?
  19. How to replace substring in mongodb document
  20. What is the default database path for MongoDB?
  21. mongo – couldn’t connect to server 127.0.0.1:27017
  22. return query based on date
  23. Querying an array of arrays in MongoDB
  24. MongoDB query with an ‘or’ condition
  25. How to remove an element from a doubly-nested array in a MongoDB document.
  26. Is there any option to limit mongodb memory usage?
  27. Mongo complex sorting?
  28. Unhandled promise rejection: Error: URL malformed, cannot be parsed
  29. How to query MongoDB to test if an item exists?
  30. Difference between count() and find().count() in MongoDB
  31. Rounding to 2 decimal places using MongoDB aggregation framework
  32. What does it mean to fit “working set” into RAM for MongoDB?
  33. How to enable authentication on MongoDB through Docker?
  34. Is shortening MongoDB property names worthwhile?
  35. Mongodb aggregation lookup with conditions
  36. How do I start Mongo DB from Windows?
  37. NoSQL (MongoDB) vs Lucene (or Solr) as your database [closed]
  38. MongoDB: output ‘id’ instead of ‘_id’
  39. MongoDB select count(distinct x) on an indexed column – count unique results for large data sets
  40. How does sorting with an index work in MongoDB?
  41. How to return just the nested documents of an array from all documents
  42. $skip and $limit in aggregation framework
  43. MongoDB nested array query
  44. Batch insert/update using Mongoid?
  45. MongoDB – is DBREF necessary?
  46. MongoDB $or query
  47. How can I sort into that nulls are last ordered in mongodb?
  48. Performing case-statement in mongodb aggregation framework
  49. saving picture to mongodb
  50. $unwind an object in aggregation framework

Leave a Comment