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?

The /.../ syntax is only for strings, not variables. Many of the answers in the question you've linked provide your answer. — JohnnyHK, May 02 '17 at 04:27

score 87 · Accepted Answer · answered May 02 '17 at 04:17

87

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);

answered May 02 '17 at 04:17

kumbhani bhavesh

2,189
1
15
26

1

Thanks for your answer. Above find is case-sensitive. how can I do this with case-insensitive? – Lead Developer Dec 03 '17 at 12:28
6

Have you read a documentation [how to use regex](https://docs.mongodb.com/manual/reference/operator/query/regex/)? you need to use `{ : { $regex: 'pattern', $options: '' } }` with options `i`, e.g. `{ name: { $regex: req.params.keyword, $options: 'i' } }` – Aliaksandr Pyrkh Apr 04 '18 at 22:31
2

`i` is use for case insensitive – kumbhani bhavesh Apr 05 '18 at 05:11
You can add options after the regex pattern as usual. `/pattern/i` – Erisan Olasheni Aug 05 '21 at 00:01

score 28 · Answer 2 · answered Apr 04 '19 at 10:57

28

Or just simply

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

i for case-insensitive

answered Apr 04 '19 at 10:57

Nux

5,890
13
48
74

score 13 · Answer 3 · answered Jun 15 '20 at 09:05

This is how i have done it to find if search string present in name/email. Hope it helps someone.

const getPeerSuggestions = async (req, res, next) => {

  const { search } = req.query;
  const rgx = (pattern) => new RegExp(`.*${pattern}.*`);
  const searchRgx = rgx(search);

  const peers = await User.find({
    $or: [
      { name: { $regex: searchRgx, $options: "i" } },
      { email: { $regex: searchRgx, $options: "i" } },
    ],
  })
    .limit(5)
    .catch(next);

  res.json(peers);
};

score 9 · Answer 4 · answered Oct 27 '18 at 22:55

You can use the RegExp object to make a regex with a variable, add the 'i' flag if you want the search to be case insensitive.

const mongoose = require('mongoose');
const User = mongoose.model('user');

const userRegex = new RegExp(userNameVariable, 'i')
return User.find({name: userRegex})

score 1 · Answer 5 · answered Feb 23 '21 at 15:23

1

Without aggregate it didn't work for me. But this did:

db.dbname.aggregate([{ "$match" : {"name" : { $regex: '.*SERGE.*', $options: 'i' } }}, { $sort: { "createdTime" : -1 }} ]).pretty()

answered Feb 23 '21 at 15:23

sklimkovitch

251
4
8

score 1 · Answer 6 · edited Nov 05 '21 at 19:20

1

 select * from table where abc like %_keyword%

in mongo it is

  const list = await ProductModel.find({{ pname :{ $regex : '.*'+ _keyword + '.*' }});

here _keyword can be any text eg. fruit, pen, etc. as i am searching products model.

edited Nov 05 '21 at 19:20

Nolequen

3,032
6
36
55

answered Nov 03 '21 at 11:29

Umer Baba

285
3
4

score 0 · Answer 7 · answered Aug 05 '21 at 00:06

0

You can run a regex lookup with dynamic values using RegExp:

 var promise = UserSchema.find({name: new RegExp(req.params.keyword, 'i') }).limit(5);

Notice the 'i' option for case insensitivity.

answered Aug 05 '21 at 00:06

Erisan Olasheni

2,395
17
20

How I can use "LIKE" operator on mongoose?

7 Answers7

Linked

Related