如何使用SQL“赞"在PyMongo中? [英] How use sql "like" in PyMongo?

问题描述

如何在PyMongo中使用sql"like"?

How use sql "like" in PyMongo?

>>> db.houses.find().count()
11616
>>> db.houses.find({"hid":u"16999"}).count()
1
>>> db.houses.find({"hid":u"/9/"}).count()
0

文档表示sql喜欢" MongoDB中的(SELECT * FROM users WHERE name LIKE "%Joe%")是db.users.find ({name:/Joe/}).

The documentation says that sql "like" (SELECT * FROM users WHERE name LIKE "%Joe%") in MongoDB is db.users.find ({name:/Joe/}).

如果您直接向cli-client接口mongodb指定一个查询，则一切正常，但在pymongo中不起作用.

If you specify a query directly to the cli-client interface mongodb, then everything works correctly, but does not work in pymongo.

出什么问题了?

谢谢.

推荐答案

pymongo不支持正则表达式文字，您必须使用'$ regex'谓词:

pymongo doesn't support regex literals, you have to use the '$regex' predicate:

 db.houses.find({"hid":{"$regex": u"9"}})

这篇关于如何使用SQL“赞"在PyMongo中?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！