使用Python进行MongoDB的条件查询

import pymongo
#连接MongoDB数据库
client = pymongo.MongoClient(host="localhost", port=27017)
#指定数据库
db = client["my_database"]
#指定集合
collection = db["my_collection"]

#查询pidancode.com的文档记录
query = {"name": "pidancode.com"}
result = collection.find(query)
#遍历结果
for x in result:
    print(x)

#查询名称中包含“编程”的文档记录
query = {"name": {"$regex": ".*编程.*"}}
result = collection.find(query)
#遍历结果
for x in result:
    print(x)

#查询age大于等于18且小于30的文档记录
query = {"age": {"$gte": 18, "$lt": 30}}
result = collection.find(query)
#遍历结果
for x in result:
    print(x)

#查询age大于等于18或者name为“皮蛋编程”的文档记录
query = {"$or":[{"age":{"$gte":18}},{"name":"皮蛋编程"}]}
result = collection.find(query)
#遍历结果
for x in result:
    print(x)