Mongodb find all except from one or two criteria

mongodb pymongo mongodb-query
Diolor picture Diolor · Aug 26, 2013 · Viewed 15.6k times · Source

Alright for one field matching I run:

db.bios.find( { "Country":"Netherlands" } )

How can I bring all documents but not the ones with "Country":"Netherlands"?

Also is it possible to bring all documents but without 2 countries?

Answer

Yevgeniy Anfilofyev picture Yevgeniy Anfilofyev · Aug 26, 2013

Use $nin operator

For example:

db.bios.find( { Country: { $nin: ["Country1", "Country2"] } } )

And $ne for just one country:

db.bios.find( { Country: { $ne: "Country1" } } )

Related questions

Query Mongodb on month, day, year... of a datetime

I'm using mongodb and I store datetime in my database in this way for a date "17-11-2011 18:00" I store: date = datetime.datetime(2011, 11, 17, 18, 0) db.mydatabase.mycollection.insert({"date" : date}) I would like to do a request like that month = 11 db.…

Read More
How to convert a pymongo.cursor.Cursor into a dict?

I am using pymongo to query for all items in a region (actually it is to query for all venues in a region on a map). I used db.command(SON()) before to search in a spherical region, which can …

Read More
How can I use 'Not Like' operator in MongoDB

I can use the SQL Like Operator using pymongo, db.test.find({'c':{'$regex':'ttt'}}) But how can I use Not Like Operator? I tried db.test.find({'c':{'$not':{'$regex':'ttt'}}) but got error: OperationFailure: $not …

Read More