In mongodb how to ignore case sentive case?

Question

db.tasks.find({ name: {$regex: '^T',$options: "x"}},{name:1});

it working fine when I enter Capital Letter for example T but when I enter lower case letter for example it is not working

db.tasks.find({name: {$regex: '^[a-zA-z]T',$options: "x" }}, {name:1});

Please help me

use `$option: "ix"` for case insensitive – felix May 15 '17 at 13:35 — felix, May 15 '17 at 13:35
Have you even tried to google? :v – p.streef May 15 '17 at 13:55 — p.streef, May 15 '17 at 13:55

score 1 · Answer 1 · edited May 23 '17 at 12:34

1

I would suggest if you're using mongo3X version please go for case-insensitive collation index.

MongoDB introduced this concept in it's 3.4 version. You can use this case-insensitive search over even high volumes of data.

Please refer this link to get more idea on how it works.

Moreover you can use regex as well, But it is purely depends on your requirements how frequently you need to query for case-sensitive text.

Hope this will helpful for you.!

edited May 23 '17 at 12:34

Community

answered May 16 '17 at 07:31

Ravi kumar

now i set default_language none and it is working. Thanks – Anurag Gupta May 17 '17 at 12:43

1 Answers1