String or integer query in mongoDB for a single field

Question

In MongoDB, there is field named vehId. It contains value in string as well in integer. like

{
"vehId" : "12"
}

or

{
"vehId" : 12
}

or

{
"vehId" : ""
}

If I do query as vehId as integer it return only vehId having value in Integer as for string it return only string. But I need a single query for both string and integer . Like

collection.find({"vehId" : <value> })

I need a single query that return all value. If I pass vehId as integer it also return values having vehId in string and vice-versa

So just supply both the integer and string values as an argument to $in. — Blakes Seven
– Blakes Seven, Commented Dec 14, 2015 at 6:21
@BlakesSeven I am getting only one value, it may be string or integer — Ashutosh
– Ashutosh, Commented Dec 14, 2015 at 6:24
Blakes is asking to run query like collection.find({"vehId" : { $in: [12, "12"}}) — Sarath Nair
– Sarath Nair, Commented Dec 14, 2015 at 6:28

David Gourde · Accepted Answer · 2017-12-07 05:53:26Z

5

So If you have situation like above, you can get your results easily with:

collection.find({"vehId" : { $in: [intval($vehId), $vehId}})

edited Dec 7, 2017 at 5:53

David Gourde

3,9442 gold badges36 silver badges75 bronze badges

answered Dec 14, 2015 at 11:13

Ashutosh

6241 gold badge5 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

evilReiko Over a year ago

I strongly don't recommend this approach, unless you're sure that $vehId is always going to contain only numeric value. For example, if $vehId = '123abc', then your script will match 123 AND '123abc' !

Ashutosh Over a year ago

In db $vehId is always integer and its auto incremented.

rafettopcu · Accepted Answer · 2020-02-26 09:58:14Z

0

collection.find({ $or: [{"vehId":value}, {"vehId": intval(value)}})

answered Feb 26, 2020 at 9:58

rafettopcu

411 silver badge2 bronze badges

Collectives™ on Stack Overflow

String or integer query in mongoDB for a single field

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related