regular sql distinct in mongo

Question

PHP

Good day habr!
I'm on the verge of writing my own bike. We need to fetch a set of unique records from mongo, but at the same time we need to return the entire documents, and not just the values ​​of the specified key. In the mongo manual ( docs.mongodb.org/manual/reference/command/distinct/ ) and the php manual on mongo classes ( php.net/manual/ru/mongocollection.distinct.php ), I did not find such an opportunity (maybe bad or not looking there?). It's hard to believe that you can't get the standard output of various documents.

Answer 1

This is because sql has nothing to do with it and there is no need to stretch the methods of one paradigm to another.
{firstname:"John",lastname:"Doe"}
{firstname:"John",lastname:"Doe",dead:true} Are they
the same documents? Or different? In mongo, there is no data schema in the database, so all the processing work falls on the shoulders of the programmer. Either solve the problem with the available means, or reformulate it.