How I can use "LIKE" operator on mongoose?

Question

I have a problem when i query using mongoose.I coding follow this Mongoose.js: Find user by username LIKE value. But it return blank.

This my code return blank.

 var promise = UserSchema.find({name: /req.params.keyword/ }).limit(5); 

I tried this return blank seem.

var n = john; var promise = UserSchema.find({name: /n/ }).limit(5);

But i tried this is working

 var promise = UserSchema.find({name: /john/ }).limit(5); 

Why I use variable then return blank?

Answer 1

use $regex in mongodb

how to use regex

example

select * from table where abc like %v% 

in mongo

 var colName="v";  models.customer.find({ "abc": { $regex: '.*' + colName + '.*' } },    function(err,data){          console.log('data',data);   }); 

Your query look like

var name="john"; UserSchema.find({name: { $regex: '.*' + name + '.*' } }).limit(5); 

Answer 2

Or just simply

const name = "John" UserSchema.find({name: {$regex: name, $options: 'i'}}).limit(5); 

i for case-insensitive