PeterBechP PeterBechP - 4 months ago 105
Node.js Question

Mongoose.js: Find user by username LIKE value

I like to to go find a user in mongoDb by looking for a user called value.
The problem with:

username: 'peter'


is that i dont find it if the username is "Peter", or "PeTER".. or something like that.

So i want to do like sql

SELECT * FROM users WHERE username LIKE 'peter'


Hope you guys get what im askin for?

Short: 'field LIKE value' in mongoose.js/mongodb

Answer

Well. Just for people who are lookin for the answer i was i did like this

var name = 'Peter';
model.findOne({name: new RegExp('^'+name+'$', "i")}, function(err, doc) {
  //Do your action here..
});
Comments