Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MongoDB - How to select only numeric strings / Check whether string is numeric in mongo-shell

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?

like image 233
Jenninha Avatar asked May 17 '13 21:05

Jenninha


1 Answers

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+$/})
like image 105
JohnnyHK Avatar answered Nov 15 '22 04:11

JohnnyHK