Mongodb Query To select records having a given key

Question

The records in my database are

{"_id":"1","fn":"sagar","ln":"Varpe"}  {"_id":"1","fn":"sag","score":"10"}  {"_id":"1","ln":"ln1","score":"10"}  {"_id":"1","ln":"ln2"}  

I need to design a MongoDB query to find all records that have a given key.

For example, if I pass ln as a parameter to the query it shuold return all records in which lnis a key. The results would be

{"_id":"1","fn":"sagar","ln":"Varpe"}  {"_id":"1","ln":"ln1","score":"10"}  {"_id":"1","ln":"ln2"}  

Answer 1

To find if a key/field exists in your document use the $exists operator.

Via the MongoDB shell ...

db.things.find( { ln : { $exists : true } } ); 

Answer 2

I had the same problem and

db.coll.find({"mykey":{'$exists': 1}}) 

worked for me