python mongodb regex: ignore case

Question

How can I specify a REGEX and ignore the case:

regex = ".*" + filter + ".*";
config.gThingCollection.find({"name":{"$regex":regex}})

I want the filter to be case-insensitive, how to achieve that?

Answer 1

Try using the python regex objects instead. Pymongo will serialize them properly:

import re
config.gThingCollection.find({"name": re.compile(regex, re.IGNORECASE)})

Answer 2

You can use MongoDB regex options in your query.

config.gThingCollection.find({"name":{"$regex":regex, "$options": "-i"}})