CODEWITHSUNDEEP
javascriptnode.jsmongodb
teddy
teddy

Reputation: 53

Nodejs - MongoDB findone with exact match but case insensitive

db.collection("accounts").findOne({Nickname: { $regex : new RegExp(player, "i") }}, function(err, result) { }

Is what I currently have, the problem is that I get everything that is a substring of the player variable. But I want only exact, albeit case-insensitive matches.

Upvotes: 4

Views: 3692

Answers (2)

Kjell-Morten
Kjell-Morten

Reputation: 73

Your regex actually asks for a substring. To ask for an exact string:

new RegExp("^" + player + "$", "i")

(Keep everything else the same.)

The ^ matches the beginning of the input, the $ matches the end. This way, any substrings won't match.

Upvotes: 5

Vasan
Vasan

Reputation: 4956

Prefix player with ^ and suffix with $, so that it matches the entire string

"^" + player + "$"

^ matches the start of the string

$ matches the end of the string

Reference for boundary regex characters

So with this expression you're saying "find me Nickname which starts and ends with this string" i.e. the entire string

Upvotes: 4

Related Questions