Analogue of "SELECT * WHERE city != null" in Mongoose

Question

The question is, how to find data in my db, where city != null?

       userdata.find({ /*???*/ }, function (err, results) {
         if (!err) console.log(results)
         ...
       });

score 1 · Answer 1 · answered Jul 19 '17 at 01:45

1

you can use $exists. The documentation is here

it should be like this

useedata.find({ city: { $exists: true } }, function(error, results) {
  if (!error) console.log('results' + results)
})

answered Jul 19 '17 at 01:45

struckbylightning

It is correct, but I have data in my collection with value "null"... – Bim Bam Jul 19 '17 at 01:48
2

then you can use **userdata.find({ city: { $not: null } })** – struckbylightning Jul 19 '17 at 01:51

1 Answers1