如何限制从MongoDB中的字段返回的字符数?
要限制从字段返回的字符数,请在MongoDB中使用$substr。让我们创建一个包含文档的集合-
> db.demo233.insertOne({"Paragraph":"My Name is John Smith.I am learning MongoDB database"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5e41877df4cebbeaebec5146")
}
> db.demo233.insertOne({"Paragraph":"David Miller is a good student and learning Spring and Hibernate Framework."});
{
"acknowledged" : true,
"insertedId" : ObjectId("5e4187d7f4cebbeaebec5147")
}在find()方法的帮助下显示集合中的所有文档-
> db.demo233.find().pretty();
这将产生以下输出-
{
"_id" : ObjectId("5e41877df4cebbeaebec5146"),
"Paragraph" : "My Name is John Smith.I am learning MongoDB database"
}
{
"_id" : ObjectId("5e4187d7f4cebbeaebec5147"),
"Paragraph" : "David Miller is a good student and learning Spring and Hibernate Framework."
}以下是查询以限制从MongoDB中的字段返回的字符数-
> db.demo233.aggregate(
... [
... {
... $project:
... {
... Paragraph: { $substr: [ "$Paragraph", 0, 10] }
...
... }
...} ] )这将产生以下输出-
{ "_id" : ObjectId("5e41877df4cebbeaebec5146"), "Paragraph" : "My Name is" }
{ "_id" : ObjectId("5e4187d7f4cebbeaebec5147"), "Paragraph" : "David Mill" }热门推荐
10 新年门口花束祝福语简短
11 盘锦结婚祝福语大全简短
12 父母生日祝福语 简短独特
13 家庭恩爱祝福语简短英文
14 高考俄语祝福语大全简短
15 虎年祝福语 诗句唯美简短
16 生日婚礼祝福语简短精辟
17 虎年喝酒拜年祝福语简短
18 教师闺蜜祝福语简短