Query with like in MongoDB

Question

How can I do a like query in MongoDB using Node.js?

Here's my source code, but it doesn't work:

exports.findAll = function(req, res) {
    var country=req.params.country; 
    db.collection('wines', function(err, collection) {
        collection.find({ 'country': new RegExp('/'+country+'/i') }).toArray(function(err, items) {
            res.jsonp(items);
        });
    });
};

possible duplicate of [Mongoose find query doesn't work even equivalent query works fine on mongodb](http://stackoverflow.com/questions/14804168/mongoose-find-query-doesnt-work-even-equivalent-query-works-fine-on-mongodb) — JohnnyHK, Jun 27 '13 at 22:04
Heres I found the solution: http://stackoverflow.com/questions/14804168/mongoose-find-query-doesnt-work-even-equivalent-query-works-fine-on-mongodb — Alexander Ceballos, Jun 27 '13 at 22:13
you can find here: https://stackoverflow.com/a/71136307/14229690 — Sahil Thummar, Apr 30 '22 at 17:21

score 17 · Accepted Answer · edited Nov 24 '18 at 02:05

17

I solved it like this:

 exports.findAll = function(req, res) {
        var country=req.params.country; 
        db.collection('wines', function(err, collection) {
            collection.find({ 'country': new RegExp(country, 'i') }).toArray(function(err, items) {
                res.jsonp(items);
            });
        });
    };

edited Nov 24 '18 at 02:05

Ethan

4,295
4
25
44

answered Aug 02 '13 at 21:06

Alexander Ceballos

750
2
20
36

how to use this find regex in dynamic key? ex : var key = request.body.key; find({ key : new RegExp(country, 'i') }); I've tried this but still the key is considered not as string – Angger Mar 05 '18 at 04:22
what is 'i' in this? – Apoorv Apr 26 '18 at 18:26
1

case insensitive search – Alexander Ceballos Apr 26 '18 at 22:31
If we want to apply on mongoose _id then this "new RegExp(req.query.search, 'i');" not work. Anybody know how to solve this? – Naisarg Parmar Dec 05 '19 at 03:00

Query with like in MongoDB

1 Answers1