Random record from MongoDB

by

Starting with the 3.2 release of MongoDB, you can get N random docs from a collection using the $sample aggregation pipeline operator:

// Get one random document from the mycoll collection.
db.mycoll.aggregate([{ $sample: { size: 1 } }])

If you want to select the random document(s) from a filtered subset of the collection, prepend a $match stage to the pipeline:

// Get one random document matching {a: 10} from the mycoll collection.
db.mycoll.aggregate([
    { $match: { a: 10 } },
    { $sample: { size: 1 } }
])

As noted in the comments, when size is greater than 1, there may be duplicates in the returned document sample.

More Related Contents:

  1. How can I get a random record from MongoDB?
  2. Does MongoDB’s $in clause guarantee order
  3. $lookup on ObjectId’s in an array
  4. How to query nested objects?
  5. Update field in exact element array in MongoDB
  6. How to find MongoDB field name at arbitrary depth
  7. Return only matched sub-document elements within a nested array
  8. Converting string to date in mongodb
  9. Querying internal array size in MongoDB
  10. MongoDB wildcard in the key of a query
  11. MongoDB nested lookup with 3 levels
  12. MongoDB Full and Partial Text Search
  13. Mongodb Join on _id field from String to ObjectId
  14. Difference between count() and find().count() in MongoDB
  15. How to get back the Original document back after aggregation
  16. How to insert an element to MongoDB internal list?
  17. MongoDB lookup when foreign field is an array of objects
  18. Get the latest record from mongodb collection
  19. Search on multiple collections in MongoDB
  20. How to ignore nulls while unmarshalling a MongoDB document?
  21. Mongodb query specific month|year not date
  22. Remove Duplicates from MongoDB
  23. How to stop insertion of Duplicate documents in a mongodb collection
  24. MongoDB nested array query
  25. How does MongoDB order their docs in one collection? [duplicate]
  26. How to toggle a boolean field in one document with atomic operation?
  27. Update embedded object inside array inside array in MongoDB
  28. count array occurrences across all documents with mongo
  29. Mongodb concat int and string
  30. MongoDB $lookup on nested document

Leave a Comment