MongoDB how to search by using regex but avoiding case sensitive?

Question

Here is what I have done so far

filter := bson.M{
    "$or": bson.A{
        bson.M{"title": bson.M{"$regex": "input"}},
        bson.M{"author": bson.M{"$regex": "input"}},
        bson.M{"content": bson.M{"$regex": "input"}},
    },
}

p.postProposalCollection.Find(ctx, filter)

but it is case sensitive, is there anyway to lowercase the column title, author, content then try to search with regex.

See: https://stackoverflow.com/questions/9655164/regex-ignore-case-sensitivity — prasad_, Jun 29 '22 at 01:27

score 1 · Accepted Answer · answered Jun 29 '22 at 04:49

1

To do the case-insensitive regex search, you can use the Regex primitive with "i" flag:

bson.M{"title": bson.M{"$regex": primitive.Regex{Pattern: "input", Options: "i"}}},

See here and here for details.

answered Jun 29 '22 at 04:49

jabbson

4,390
1
13
23

MongoDB how to search by using regex but avoiding case sensitive?

1 Answers1