在MongoDB $ in中设置正则表达式？
让我们创建一个包含文档的集合-
> db.demo675.insertOne({
... "ListOfNames":["John","Chris","David"]});
{
"acknowledged" : true,
"insertedId" : ObjectId("5ea3f5b404263e90dac943ef")
}
> db.demo675.insertOne({ "ListOfNames":["Bob","Johnson","Sam"]});
{
"acknowledged" : true,
"insertedId" : ObjectId("5ea3f5c804263e90dac943f0")
}
> db.demo675.insertOne({ "ListOfNames":["Jace","Sam"]});
{
"acknowledged" : true,
"insertedId" : ObjectId("5ea3f5d304263e90dac943f1")
}在find()方法的帮助下显示集合中的所有文档-
> db.demo675.find();
这将产生以下输出-
{ "_id" : ObjectId("5ea3f5b404263e90dac943ef"), "ListOfNames" : [ "John", "Chris", "David" ] }
{ "_id" : ObjectId("5ea3f5c804263e90dac943f0"), "ListOfNames" : [ "Bob", "Johnson", "Sam" ] }
{ "_id" : ObjectId("5ea3f5d304263e90dac943f1"), "ListOfNames" : [ "Jace", "Sam" ] }以下是使用regexp和array查询的查询-
> db.demo675.find({"ListOfNames": {$in:[/John/,/J/]}});这将产生以下输出-
{ "_id" : ObjectId("5ea3f5b404263e90dac943ef"), "ListOfNames" : [ "John", "Chris", "David" ] }
{ "_id" : ObjectId("5ea3f5c804263e90dac943f0"), "ListOfNames" : [ "Bob", "Johnson", "Sam" ] }
{ "_id" : ObjectId("5ea3f5d304263e90dac943f1"), "ListOfNames" : [ "Jace", "Sam" ] }热门推荐
10 儿童励志寄语简短祝福语
11 冬至祝福语简短情话高级
12 订婚祝福语简短诗句
13 公司拍摄祝福语大全简短
14 学生励志祝福语大全简短
15 年末祝福语简短小清新
16 鸡脚结婚祝福语大全简短
17 女神节医生祝福语简短
18 高考录取庆贺祝福语简短