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.

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.

• javascript
• node.js
• mongodb

Share Improve this question Follow asked Mar 16, 2018 at 21:23 teddyteddy 5311 silver badge33 bronze badges

Add a ment  | 

2 Answers 2

Sorted by: Reset to default 5

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.

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