Loading...

XML

Word

Printable

JSON

Operating System:
ALL
Steps To Reproduce:

Hide

When using : { email : { $regex : "bob\.lastname", $options : "i"}} it returns the document (which is ok)
BUT when using : { email : { $regex : "b\.lastname", $options : "i"}} it also returns the document which should not happen. I expect only a match on "b.lastname"

Show
When using : { email : { $regex : "bob\.lastname", $options : "i"}} it returns the document (which is ok) BUT when using : { email : { $regex : "b\.lastname", $options : "i"}} it also returns the document which should not happen. I expect only a match on "b.lastname"
CAR Domain/s:
None

I have a document where i store a email adres, on insert of a new document i want to check if the email adres is already in use.

See the document below with a simple (yes i know not ok) email, i just want 1 dot to simplify

{ "_id" : ObjectId("5911b0ce055cdb7a64d79892"), "first_name" : "Bob", "last_name" : "Lastnam", "email" : "bob.lastname" }

I use a $regex to search if there are already documents present with the email. i escape the "special" dot so it's handled like a literal.