3 ms·
SELECT jdoc->'guid', jdoc->'name' FROM api WHERE jdoc @> '{"tags": ["qui"]}'; vs db.api.find({tags:"qui"}, {guid:1, name:1})
by Beefin 6y ago
SELECT jdoc->'guid', jdoc->'name' FROM api
WHERE jdoc @> '{"tags": ["qui"]}';
vs
db.api.find({tags:"qui"}, {guid:1, name:1})
- takeda 6y agoNot sure what you are trying to show here, but only SQL statement helped me to understand that {guid: 1, name: 1} is to show these fields.