Home Database MongoDB How to sort documents and display only a single field in MongoDB 4?

How to sort documents and display only a single field in MongoDB 4?

Sep 01, 2023 pm 02:41 PM

如何在 MongoDB 4 中对文档进行排序并仅显示单个字段?

To sort documents in MongoDB 4, use sort(). To display only a single sorted field, set this to 1.

Let us create a collection containing documents -

> db.demo611.insertOne({"Name":"Chris"});{
   "acknowledged" : true, "insertedId" : ObjectId("5e987110f6b89257f5584d83")
}
> db.demo611.insertOne({"Name":"Adam"});{
   "acknowledged" : true, "insertedId" : ObjectId("5e987115f6b89257f5584d84")
}
> db.demo611.insertOne({"Name":"John"});{
   "acknowledged" : true, "insertedId" : ObjectId("5e987118f6b89257f5584d85")
}
> db.demo611.insertOne({"Name":"Bob"});{
   "acknowledged" : true, "insertedId" : ObjectId("5e98711bf6b89257f5584d86")
}

Display all the documents in the collection with the help of find() method-

> db.demo611.find();
This will produce the following output:
{ "_id" : ObjectId("5e987110f6b89257f5584d83"), "Name" : "Chris" }
{ "_id" : ObjectId("5e987115f6b89257f5584d84"), "Name" : "Adam" }
{ "_id" : ObjectId("5e987118f6b89257f5584d85"), "Name" : "John" }
{ "_id" : ObjectId("5e98711bf6b89257f5584d86"), "Name" : "Bob" }

The following is how to sort the documents using MongoDB 4 The query -

> db.demo611.find().sort({Name:1});

will produce the following output&mius;

{ "_id" : ObjectId("5e987115f6b89257f5584d84"), "Name" : "Adam" }
{ "_id" : ObjectId("5e98711bf6b89257f5584d86"), "Name" : "Bob" }
{ "_id" : ObjectId("5e987110f6b89257f5584d83"), "Name" : "Chris" }
{ "_id" : ObjectId("5e987118f6b89257f5584d85"), "Name" : "John" }

The above is the detailed content of How to sort documents and display only a single field in MongoDB 4?. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undress AI Tool

Undress AI Tool

Undress images for free

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

PHP Tutorial
1510
276
What are the limitations of MongoDB's free tier offerings (e.g., on Atlas)? What are the limitations of MongoDB's free tier offerings (e.g., on Atlas)? Jul 21, 2025 am 01:20 AM

MongoDBAtlas' free hierarchy has many limitations in performance, availability, usage restrictions and storage, and is not suitable for production environments. First, the M0 cluster shared CPU resources it provides, with only 512MB of memory and up to 2GB of storage, making it difficult to support real-time performance or data growth; secondly, the lack of high-availability architectures such as multi-node replica sets and automatic failover, which may lead to service interruption during maintenance or failure; further, hourly read and write operations are limited, the number of connections and bandwidth are also limited, and the current limit can be triggered; finally, the backup function is limited, and the storage limit is easily exhausted due to indexing or file storage, so it is only suitable for demonstration or small personal projects.

What is the difference between updateOne(), updateMany(), and replaceOne() methods? What is the difference between updateOne(), updateMany(), and replaceOne() methods? Jul 15, 2025 am 12:04 AM

The main difference between updateOne(), updateMany() and replaceOne() in MongoDB is the update scope and method. ① updateOne() only updates part of the fields of the first matching document, which is suitable for scenes where only one record is modified; ② updateMany() updates part of all matching documents, which is suitable for scenes where multiple records are updated in batches; ③ replaceOne() completely replaces the first matching document, which is suitable for scenes where the overall content of the document is required without retaining the original structure. The three are applicable to different data operation requirements and are selected according to the update range and operation granularity.

MongoDB Atlas vs. Self-Hosted MongoDB: Which is Right for You? MongoDB Atlas vs. Self-Hosted MongoDB: Which is Right for You? Jul 30, 2025 am 12:50 AM

MongoDBAtlas is more suitable for small teams or organizations lacking DBA resources because it provides fully automatic management, rapid deployment and built-in security; 2. Atlas is transparent and easy to budget in the early stage, but it may be higher than self-hosting after large usage. Although the infrastructure fee is low, it needs to be included in the labor and risk costs; 3. In terms of security and compliance, Atlas defaults to enterprise-level configuration and automatically updates, and self-hosting needs to be implemented manually and is prone to errors; 4. Select from hosting when it requires strong control, customization needs or data sovereignty restrictions, otherwise most teams should choose Atlas first to focus on product development rather than operation and maintenance. This choice is the most time-saving and reliable and supports flexible adjustments in the future.

What are transactions in MongoDB, and how do they provide ACID properties for multi-document operations? What are transactions in MongoDB, and how do they provide ACID properties for multi-document operations? Jul 31, 2025 am 06:25 AM

MongoDBintroducedmulti-documenttransactionsinversion4.0,enablingatomicoperationsacrosscollectionsforstrongconsistency.Transactionsallowmultipleread/writeoperationstobegroupedasasingleunit,eitherallsucceedingorfailingtogether.Theyaresupportedinreplica

Best Practices for Backing Up and Restoring a MongoDB Database Best Practices for Backing Up and Restoring a MongoDB Database Jul 27, 2025 am 12:33 AM

Usemongodumpandmongorestoreforlogicalbackups,preferablyonsecondarynodeswithcompressionandproperoptionsforrolesandcollections.2.Forlargeorproductionsystems,usefilesystemsnapshotslikeLVMorAWSEBSbystoppingthesecondarynodetoensureconsistencyandcapturedat

What is the significance of the working set, and how does it relate to RAM capacity? What is the significance of the working set, and how does it relate to RAM capacity? Jul 17, 2025 am 12:20 AM

TheworkingsetdirectlyimpactssystemperformancebecauseifitexceedsavailableRAM,thesystemslowsdownduetopaging.1)Theworkingsetconsistsofactivedataandinstructionsfromrunningprograms,notjustopenapps.2)Itdynamicallychangesbasedoncurrenttasksandincludesbothco

How does connection pooling work with MongoDB drivers, and why is it important? How does connection pooling work with MongoDB drivers, and why is it important? Jul 16, 2025 am 01:30 AM

MongoDBconnectionpoolingworksbymaintainingreusabledatabaseconnectionstoimproveperformance.1)Driverscreateinitialconnectionsatappstart.2)Whenaqueryruns,anidleconnectionistakenfromthepool.3)Afteruse,theconnectionreturnstothepoolinsteadofclosing.4)Ifall

Understanding MongoDB Storage Engines: WiredTiger Deep Dive Understanding MongoDB Storage Engines: WiredTiger Deep Dive Aug 04, 2025 am 05:49 AM

WiredTigerisMongoDB’sdefaultstorageenginesinceversion3.2,providinghighperformance,scalability,andmodernfeatures.1.Itusesdocument-levellockingandMVCCforhighconcurrency,allowingreadsandwritestoproceedwithoutblockingeachother.2.DataisstoredusingB-trees,

See all articles