How do I do greater than/less than using MongoDB?


I'm using the pymongo driver.

Can someone take a look at pymongo and tell me how to do greater than? I"m used to doing : for everything.

9/22/2017 5:57:57 PM

Accepted Answer

Have you seen the doc ? Take from the manual :

>>> d = datetime.datetime(2009, 11, 12, 12)
>>> for post in posts.find({"date": {"$lt": d}}).sort("author"):
...   post
{u'date': datetime.datetime(2009, 11, 10, 10, 45), u'text': u'and pretty easy too!', u'_id': ObjectId('...'), u'author': u'Eliot', u'title': u'MongoDB is fun'}
{u'date': datetime.datetime(2009, 11, 12, 11, 14), u'text': u'Another post!', u'_id': ObjectId('...'), u'author': u'Mike', u'tags': [u'bulk', u'insert']}
1/16/2018 12:35:28 PM

If you wanna query and find docs which have a field greater than something you can

users.find({"age": {"$gt": 20}})

Check out the advanced query section of Mongodb for more reference.


Licensed under: CC-BY-SA with attribution
Not affiliated with: Stack Overflow