How to make eq case insensitive?

how to make eq case insensitive?

... eq(username, "Abc")

if want it to be true for “abc” and vice versa (I have “Abc” in my DB and want it to be equal with “abc” search).

It is possible or I need term index and use all/any/ofterms?

I think the regex will work with trigram index: regex(field,/abc/i)

(The i is the case insensitive flag)

1 Like

I will try that. Thanks.

I will need to add new index for that - terms is also case insensitive and I wonder what is faster - term or trigram?

Term will most likey be faster. In my experience a regex filter/index is the most expensive.

1 Like