Skip to content

Instantly share code, notes, and snippets.

@libbkmz
Created August 16, 2013 21:49
Show Gist options
  • Select an option

  • Save libbkmz/6253766 to your computer and use it in GitHub Desktop.

Select an option

Save libbkmz/6253766 to your computer and use it in GitHub Desktop.
> use test
switched to db test
> db.start.insert({name: 1})
> db.start.insert({name: 2})
> db.start.insert({name: 3})
> db.start.insert({name: 4})
> db.start.insert({name: 5})
> db.start.insert({name: 6})
> db.start.insert({name: 7})
> db.start.insert({name: 8})
> db.start.insert({name: 9})
> db.start.find()
{ "_id" : ObjectId("520e9d73df9c7bf13979c3d8"), "name" : 1 }
{ "_id" : ObjectId("520e9d74df9c7bf13979c3d9"), "name" : 2 }
{ "_id" : ObjectId("520e9d76df9c7bf13979c3da"), "name" : 3 }
{ "_id" : ObjectId("520e9d77df9c7bf13979c3db"), "name" : 4 }
{ "_id" : ObjectId("520e9d78df9c7bf13979c3dc"), "name" : 5 }
{ "_id" : ObjectId("520e9d7adf9c7bf13979c3dd"), "name" : 6 }
{ "_id" : ObjectId("520e9d7bdf9c7bf13979c3de"), "name" : 7 }
{ "_id" : ObjectId("520e9d7cdf9c7bf13979c3df"), "name" : 8 }
{ "_id" : ObjectId("520e9d7edf9c7bf13979c3e0"), "name" : 9 }
> db.result.insert({name: 3})
> db.result.insert({name: 9})
> db.start.find({name: {$nin: db.result.find() } })
{ "_id" : ObjectId("520e9d73df9c7bf13979c3d8"), "name" : 1 }
{ "_id" : ObjectId("520e9d74df9c7bf13979c3d9"), "name" : 2 }
{ "_id" : ObjectId("520e9d76df9c7bf13979c3da"), "name" : 3 }
{ "_id" : ObjectId("520e9d77df9c7bf13979c3db"), "name" : 4 }
{ "_id" : ObjectId("520e9d78df9c7bf13979c3dc"), "name" : 5 }
{ "_id" : ObjectId("520e9d7adf9c7bf13979c3dd"), "name" : 6 }
{ "_id" : ObjectId("520e9d7bdf9c7bf13979c3de"), "name" : 7 }
{ "_id" : ObjectId("520e9d7cdf9c7bf13979c3df"), "name" : 8 }
{ "_id" : ObjectId("520e9d7edf9c7bf13979c3e0"), "name" : 9 }
But i want to get :
{ "_id" : ObjectId("520e9d73df9c7bf13979c3d8"), "name" : 1 }
{ "_id" : ObjectId("520e9d74df9c7bf13979c3d9"), "name" : 2 }
{ "_id" : ObjectId("520e9d77df9c7bf13979c3db"), "name" : 4 }
{ "_id" : ObjectId("520e9d78df9c7bf13979c3dc"), "name" : 5 }
{ "_id" : ObjectId("520e9d7adf9c7bf13979c3dd"), "name" : 6 }
{ "_id" : ObjectId("520e9d7bdf9c7bf13979c3de"), "name" : 7 }
{ "_id" : ObjectId("520e9d7cdf9c7bf13979c3df"), "name" : 8 }
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment