MongoDB: Is it possible to make a case-insensitive query?

by

You could use a regex.

In your example that would be:

db.stuff.find( { foo: /^bar$/i } );

I must say, though, maybe you could just downcase (or upcase) the value on the way in rather than incurring the extra cost every time you find it. Obviously this wont work for people’s names and such, but maybe use-cases like tags.

More Related Contents:

  1. Mongodb $push in nested array
  2. How to select a single field for all documents in a MongoDB collection?
  3. mongodb group values by multiple fields
  4. Conditional $sum in MongoDB
  5. mongoDB/mongoose: unique if not null
  6. arrayFilters in mongodb
  7. MongoDB password with “@” in it
  8. MongoDB: How to query for records where field is null or not set?
  9. exclude fields in $lookup aggregation
  10. Mongo how to $lookup with DBRef
  11. Add some kind of row number to a mongodb aggregate command / pipeline
  12. How to enforce foreign keys in NoSql databases (MongoDB)?
  13. How do you query for “is not null” in Mongo?
  14. MongoDB: exception in initAndListen: 20 Attempted to create a lock file on a read-only directory: /data/db, terminating
  15. MongoDB sort documents by array elements
  16. MongoDB won’t start after server crash
  17. How does sorting with an index work in MongoDB?
  18. How to use dot in field name?
  19. How to get multiple document using array of MongoDb id?
  20. Docker: change folder where to store docker volumes
  21. What is the maximum number of parameters passed to $in query in MongoDB?
  22. How to organise a many to many relationship in MongoDB
  23. Mongodb aggregation pipeline how to limit a group push
  24. Insert json file into mongodb
  25. Clone a collection in MongoDB
  26. Modify and replay MongoDB oplog
  27. Creating custom Object ID in MongoDB
  28. Return actual type of a field in MongoDB
  29. Sort nested array of objects
  30. How to create a Mongo Docker Image with default collections and data?

Leave a Comment