資料結構
網路
RDBMS
作業系統
Java
MS Excel
iOS
HTML
CSS
Android
Python
C 程式設計
C++
C#
MongoDB
MySQL
Javascript
PHP
物理
化學
生物
數學
英語
經濟學
心理學
社會研究
時尚研究
法律研究如何在 MongoDB 中檢索值以特定字元結尾的文件？
以下是 MongoDB 中檢索值以特定字元結尾的文件的語法
db.yourCollectionName.find({yourFieldName: {$regex: "yourEndingCharacter$"}}).pretty();我們首先使用文件建立一個集合
>db.retrieveDocumentsWithEndsWithParticularCharacterDemo.insertOne({"StudentName":"Adam","StudentAge":25,"StudentCountryName":"LAOS"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5c9c45b32d66697741252456")
}
>db.retrieveDocumentsWithEndsWithParticularCharacterDemo.insertOne({"StudentName":"Sam","StudentAge":24,"StudentCountryName":"ANGOLA"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5c9c45c02d66697741252457")
}
>db.retrieveDocumentsWithEndsWithParticularCharacterDemo.insertOne({"StudentName":"Robert","StudentAge":21,"StudentCountryName":"AUS"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5c9c45cb2d66697741252458")
}
>db.retrieveDocumentsWithEndsWithParticularCharacterDemo.insertOne({"StudentName":"Chris","StudentAge":20,"StudentCountryName":"UK"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5c9c45d92d66697741252459")
}
>db.retrieveDocumentsWithEndsWithParticularCharacterDemo.insertOne({"StudentName":"Larry","StudentAge":23,"StudentCountryName":"US"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5c9c45eb2d6669774125245a")
}以下是使用 find() 方法顯示集合中所有文件的查詢
> db.retrieveDocumentsWithEndsWithParticularCharacterDemo.find().pretty();
這將產生以下輸出
{
"_id" : ObjectId("5c9c45b32d66697741252456"),
"StudentName" : "Adam",
"StudentAge" : 25,
"StudentCountryName" : "LAOS"
}
{
"_id" : ObjectId("5c9c45c02d66697741252457"),
"StudentName" : "Sam",
"StudentAge" : 24,
"StudentCountryName" : "ANGOLA"
}
{
"_id" : ObjectId("5c9c45cb2d66697741252458"),
"StudentName" : "Robert",
"StudentAge" : 21,
"StudentCountryName" : "AUS"
}
{
"_id" : ObjectId("5c9c45d92d66697741252459"),
"StudentName" : "Chris",
"StudentAge" : 20,
"StudentCountryName" : "UK"
}
{
"_id" : ObjectId("5c9c45eb2d6669774125245a"),
"StudentName" : "Larry",
"StudentAge" : 23,
"StudentCountryName" : "US"
}以下是檢索 MongoDB 中值以特定字元結尾的文件的查詢。我們正在檢查以字元“S”結尾的值
> db.retrieveDocumentsWithEndsWithParticularCharacterDemo.find({StudentCountryName: {$regex: "S$"}}).pretty();這將產生以下輸出
{
"_id" : ObjectId("5c9c45b32d66697741252456"),
"StudentName" : "Adam",
"StudentAge" : 25,
"StudentCountryName" : "LAOS"
}
{
"_id" : ObjectId("5c9c45cb2d66697741252458"),
"StudentName" : "Robert",
"StudentAge" : 21,
"StudentCountryName" : "AUS"
}
{
"_id" : ObjectId("5c9c45eb2d6669774125245a"),
"StudentName" : "Larry",
"StudentAge" : 23,
"StudentCountryName" : "US"
}
更新於： 30-7-2019
1K+ 瀏覽
廣告