How can I use a regex variable in a query for MongoDB

by

I was having same problem with my title and after lots of searching, i found this answer Here,

var search="Joe";
db.users.find(name: /^search/)
db.users.find(name: {$regex: /^search/});
db.users.find(name: {$regex: "/^" + search + "https://stackoverflow.com/"});

The queries above won’t return anything. The solution to this little problem is quite simple:

db.users.find(name: new RegExp(search)) //For substring search, case sensitive. 
db.users.find(name: new RegExp('^' + search + '$')) //For exact search, case sensitive
db.users.find(name: new RegExp(search， ‘i')) //For substring search, case insensitive
db.users.find(name: new RegExp('^' +search + '$', 'i')); //For exact search, case insensitive

Other flags or properties can be added base on reference here

More Related Contents:

  1. How to send documents from my mongodb database to android application?
  2. Querying after populate in Mongoose
  3. How do I manage MongoDB connections in a Node.js web application?
  4. db.collection is not a function when using MongoClient v3.0
  5. Comparing mongoose _id and strings
  6. Why is it recommended not to close a MongoDB connection anywhere in Node.js code?
  7. How to use a variable as a field name in mongodb-native findOne()?
  8. Mongoose Unique values in nested array of objects
  9. MongoDB – Error: getMore command failed: Cursor not found
  10. Stream from a mongodb cursor to Express response in node.js
  11. MongoDB on with Docker “failed to connect to server [localhost:27017] on first connect “
  12. How to protect the password field in Mongoose/MongoDB so it won’t return in a query when I populate collections?
  13. How to get a callback on MongoDB collection.find()
  14. Fill missing dates in records
  15. Mongoose, find, return specific properties
  16. How to drop a database with Mongoose?
  17. How to use mongoose findOne
  18. Mongoose indexing in production code
  19. Meteor Subscribe doesn’t update sort order of collection
  20. Mongoose optional search query parameters?
  21. Mongodb sort with case insensitive manner
  22. Mocking database in node.js?
  23. Fail to connect Mongoose to Atlas
  24. What’s going on with Meteor and Fibers/bindEnvironment()?
  25. Which SchemaType in Mongoose is Best for Timestamp?
  26. Mongoose: ObjectId Comparisons fail inconsistently
  27. Mongodb find created results by date today
  28. Mongoose multiple connections
  29. set field as empty for mongo object using mongoose
  30. Create unique autoincrement field with mongoose [duplicate]

Leave a Comment