Searching string with special characters in MongoDB document

by

You have to escape $ by \:

db.myCollection.find({ myKey : /.*\$aus.*/i }); 
// OR
db.myCollection.find({myKey: { $regex: '.*\\$aus.*', $options: 'i'}})

You can use this:

db.myCollection.find({myKey:{ $regex:new RegExp('^' + 'test$australia'.replace(/[-\/\\^$*+?.()|[\]{}]/g, '\\$&') + '$', 'i')}})

More Related Contents:

  1. Does MongoDB’s $in clause guarantee order
  2. Update field in exact element array in MongoDB
  3. Authentication failure while trying to save to mongodb
  4. Possibility of duplicate Mongo ObjectId’s being generated in two different collections?
  5. How to change the type of a field?
  6. MongoDB logging all queries
  7. Return only matched sub-document elements within a nested array
  8. Converting string to date in mongodb
  9. Querying internal array size in MongoDB
  10. MongoDB wildcard in the key of a query
  11. How to create a DB for MongoDB container on start up?
  12. How to access a preexisting collection with Mongoose?
  13. How to delete N numbers of documents in mongodb
  14. How do I query for distinct values in Mongoose?
  15. MongoDB Full and Partial Text Search
  16. Difference between count() and find().count() in MongoDB
  17. How to insert an element to MongoDB internal list?
  18. Hierarchical queries with Mongo using $graphLookup
  19. Remove embedded document in a nested array of documents
  20. Find all documents within last n days
  21. Unable to create/open lock file: /data/mongod.lock errno:13 Permission denied
  22. Search on multiple collections in MongoDB
  23. Image returned from REST API always displays broken
  24. MongoDB: Server has startup warnings ”Access control is not enabled for the database”
  25. Mongo group and push: pushing all fields
  26. How to stop insertion of Duplicate documents in a mongodb collection
  27. MongoDB nested array query
  28. Remove multiple documents from mongo in a single query
  29. What is the difference between save and insert in Mongo DB?
  30. Aggregation with update in mongoDB

Leave a Comment