How can I perform like query for big decimal number containing decimal part in it in mongodb

Question

I have perform like query in mongodb. I have following document in employee collection as:

{
   "_id" :1
   "name":"Abc",
   "salary": 56789.98456
 }

So far,I have performed like query to match the above employee document. I have tried following queries in mongo:

db.employee.find({"salary":/.*56789.98.*/}).pretty()
db.employee.find({"salary":/^56789.98/}).pretty()
db.employee.find({"salary":/56789.98/}).pretty()

But it doesn't work. I also looked at: How to query MongoDB with "like"?

How do I achieve this in mongo ?

You need to store salary as double and also then fetch it with the query — Webdev, Feb 07 '17 at 05:03

score 1 · Accepted Answer · answered Feb 07 '17 at 06:01

1

You can do something like this:

db.employee.find({"$where":"/^56789.98.*/.test(this.salary)"})

answered Feb 07 '17 at 06:01

oblivion

5,928
3
34
55

How can I perform like query for big decimal number containing decimal part in it in mongodb

1 Answers1