How to create a search query for partial string matches in Mongoose?

Question

I'm new to Mongoose.js and I'm wondering how to create a simple Mongoose query that returns values containing the characters in the order that they were submitted.

This will be for an autocomplete form which needs to return cities with names that contain characters input into the search field. Should I start with a .where query?

Sorry, good point, the search should return values containing the strings in the order input into the search field — ac360, Nov 25 '13 at 20:50
http://stackoverflow.com/questions/35838387/how-to-find-all-the-results-containing-a-given-substring-with-spaces-in-mongoose/41398045#41398045 — Rohit Luthra, Dec 30 '16 at 14:53

score 26 · Accepted Answer · answered Nov 25 '13 at 21:03

You could find by regexp, which should allow you to search in a flexible (although not extremely fast) way. The code would be something similar to;

var input = 'ln';  // the input from your auto-complete box

cities.find({name: new RegExp(input, "i")}, function(err, docs) {
   ...
});

Of course, you could preprocess the string to make it match from the start (prepend by ^), from the end (append by $) etc. Just note that matching against arbitrary parts of long strings may be slow.

How to create a search query for partial string matches in Mongoose?

1 Answers1