MongoDB查询按单词排序
要按单词排序，请使用$addField和$cond。让我们创建一个包含文档的集合
> db.demo62.insertOne({"Subject":"MySQL"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5e287084cfb11e5c34d8992f")
}
> db.demo62.insertOne({"Subject":"MongoDB"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5e287085cfb11e5c34d89930")
}
> db.demo62.insertOne({"Subject":"Java"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5e287086cfb11e5c34d89931")
}> db.demo62.find();
{ "_id" : ObjectId("5e287084cfb11e5c34d8992f"), "Subject" : "MySQL" }
{ "_id" : ObjectId("5e287085cfb11e5c34d89930"), "Subject" : "MongoDB" }
{ "_id" : ObjectId("5e287086cfb11e5c34d89931"), "Subject" : "Java" }> db.demo62.aggregate([
... {
... $addFields: {
... sortByWords: {
... $cond: [
... { $eq: ["$Subject", "MongoDB"] },
... 0,
... { $cond: [{ $eq: ["$Subject", "MySQL"] }, 1, 2] }
... ]
... }
... }
... },
...
... {
... $sort: {
... sortByWords: 1
... }
... }
... ]);{ "_id" : ObjectId("5e287085cfb11e5c34d89930"), "Subject" : "MongoDB", "sortByWords" : 0 }
{ "_id" : ObjectId("5e287084cfb11e5c34d8992f"), "Subject" : "MySQL", "sortByWords" : 1 }
{ "_id" : ObjectId("5e287086cfb11e5c34d89931"), "Subject" : "Java", "sortByWords" : 2 }热门推荐
1 训练狗狗憋尿
2 狗狗追踪训练
3 狗狗训练要多少钱
5 深圳狗狗训练
6 训练狗狗唤回
7 狗狗叫怎么训练
8 狗狗训练班
10 狗狗社会化训练
11 狗狗叫回训练
12 广州狗狗训练学校
13 狗狗训练躺下
14 狗狗随行训练
15 训练狗狗巡回
16 狗狗要怎么训练
17 狗狗喂食训练
18 训练狗狗躺下