MongoDB/PyMongo: Querying multiple criteria - unexpected results MongoDB/PyMongo: Querying multiple criteria - unexpected results mongodb mongodb

MongoDB/PyMongo: Querying multiple criteria - unexpected results


You can use $and to join multiple conditions:

collection.find({"$and": [{"foo": {'$ne': 'bar'}},                           {"foo": {'$exists': True}}]})


No necessary to use $and, it also works

db.collection.find({"foo":{"$ne":"bar", "$exists":true}})