MongoDB $gt/$lt operators with prices stored as strings

by

If you intend to use $gt with strings, you will have to use regex, which is not great in terms of performance. It is easier to just create a new field which holds the number value of price or change this field type to int/double. A javascript version should also work, like so:

db.products.find("this.price > 30.00")

as js will convert it to number before use. However, indexes won’t work on this query.

More Related Contents:

  1. MongoDB: Combine data from multiple collections into one..how?
  2. MongoDB: Is it possible to make a case-insensitive query?
  3. MongoDB: count the number of items in an array
  4. How to remove a field completely from a MongoDB document?
  5. Multiple join conditions using the $lookup operator
  6. Aggregate $lookup Total size of documents in matching pipeline exceeds maximum document size
  7. Understanding MongoDB BSON Document size limit
  8. MongoDB – admin user not authorized
  9. How can I run MongoDB as a Windows service?
  10. MongoDB – paging
  11. Mongo complex sorting?
  12. mongo.exe not installed in Version 6.0.0
  13. MongoDB: update every document on one field
  14. multiple instances of Mongo DB on same server
  15. MongoDb shuts down with Code 100 [closed]
  16. Mongodb Query To select records having a given key
  17. MongoDB sort documents by array elements
  18. MongoDB won’t start after server crash
  19. How does sorting with an index work in MongoDB?
  20. How to use dot in field name?
  21. How to get multiple document using array of MongoDb id?
  22. Docker: change folder where to store docker volumes
  23. What is the maximum number of parameters passed to $in query in MongoDB?
  24. How to organise a many to many relationship in MongoDB
  25. Mongodb aggregation pipeline how to limit a group push
  26. How to stop mongo DB in one command
  27. MongoDB on Ubuntu won’t start as a service, nothing in the log
  28. MongoDB: how to count number of keys in a document?
  29. Mongodb concat int and string
  30. Aggregation with update in mongoDB

Leave a Comment