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 — JohnnyHK
– JohnnyHK, Commented Jun 27, 2013 at 22:04
Heres I found the solution: stackoverflow.com/questions/14804168/… — Alexander Ceballos
– Alexander Ceballos, Commented Jun 27, 2013 at 22:13

Ethan · Accepted Answer · 2018-11-24 02:05:10Z

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, 2018 at 2:05

Ethan

4,4054 gold badges27 silver badges49 bronze badges

answered Aug 2, 2013 at 21:06

Alexander Ceballos

7702 gold badges20 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Angger Over a year ago

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

Apoorv Over a year ago

what is 'i' in this?

Alexander Ceballos Over a year ago

case insensitive search

Naisarg Parmar Over a year ago

If we want to apply on mongoose _id then this "new RegExp(req.query.search, 'i');" not work. Anybody know how to solve this?

Collectives™ on Stack Overflow

Query with like in MongoDB

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related