How to query mongodb with “like” for number data type?

Asked Nov 15 '13 at 16:06

Active Nov 15 '13 at 16:06

Viewed 184 times

I need to query mongodb use 'like' clause (as in sql) for number data type. At the glance my problem is similar to this question:

How to query MongoDB with "like"?

The solution given there works perfectly for string datatype since it uses regex. However it not works if the field that need to lookup is number.For example below, the userId field of users collection has data type number and such query can get result as I expect.

// This is not working
db.users.find({"userId": /.*8788.*/})

I have tried to google and skim mongodb documentation but cannot find any solution yet.

edited May 23 '17 at 12:12

Community

asked Nov 15 '13 at 16:06

Jon Kartago Lamida

Thanks Max, I think I found the answer there. I supposed to search use "mongodb regex integer value" keywords prior to ask this question. – Jon Kartago Lamida Nov 15 '13 at 16:13

How to query mongodb with “like” for number data type?

0 Answers0