I have a collection where the fields are string but those strings can have a numeric value inside e.g.:
myObject: {
examples: [
{example: "words", ...},
{example: "more words", ...},
{example: "111", ...},
{example: "4502", ...}
...
]
...
}
How can I query "111" and "4502" and any other numeric values in string format?
You can use a regular expression in your query object to do that:
// Select docs where at least one examples element contains an example value
// that's made up only of digits.
db.test.find({'examples.example': /^\d+$/})
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With