Mongodb negative regex

Asked Oct 20 '16 at 16:27

Active Jun 25 '17 at 11:38

Viewed 12 times

How do you do a negative regex query in Mongodb?

I want to find all documents, where "Name" does not contain the string "james". E.g. filter out "james" or "john james" or "john james peter" or "somethingjames"

This works, but ONLY if the string begins with "james".

db.name.find({"name":/^((?!james).)/i});

What's wrong?

edited Sep 22 '17 at 18:01

Community

asked Oct 20 '16 at 16:27

Nima

You mean where the entry does *not* contain `james`? `/^(?!.*james)/i`? – Wiktor Stribiżew Oct 20 '16 at 16:28
@Wiktor - correct! Edited the question. I am aware of the other questions, but they dont resolve this. – Nima Oct 20 '16 at 16:36
1

Yes, the answer is at http://stackoverflow.com/a/24743196/3832970 – Wiktor Stribiżew Oct 20 '16 at 16:37
Worked - thanks a lot @Wiktor! – Nima Oct 25 '16 at 14:14

Mongodb negative regex

0 Answers0