Convert a string to a number in Shell Mongodb query

Asked May 08 '21 at 13:30

Active May 08 '21 at 13:30

Viewed 30 times

I have a Mongodb Collection in which a decimal amount is stored as a string. I would like to be able to query treating that field as a number. Is that possible without elaborate code? I would expect to be able to do. tonumber(field):{$gt:100}. But I can't find anything.

asked May 08 '21 at 13:30

m darr

Actually I have that wrong. tonumber(field):{$gt:100} – m darr May 08 '21 at 13:31
1

https://stackoverflow.com/questions/47915936/mongo-cast-string-to-number-for-query/47919019 – R2D2 May 08 '21 at 18:26

Convert a string to a number in Shell Mongodb query

0 Answers0