Applying case Insensitive filter while using pymongo's update_many

Question

Can someone suggest how to update multiple documents while using regex in filter query of update_many? Here is my query:

db['collection'].update_many({"col1":{ "$regex" : "NO" , "$options" : "i"}},{"$set":{"col2":"NO"}})

Answer 1

Here is a quick fix that I used:

no_regex = ['no','No','NO']
db['collection'].update_many({"col1":{ "$in" : no_regex}},{"$set":{"col2":"NO"}})