Redis ZSCAN MATCH case insensitive search

Question

I have a list of places stored in Redis Sorted Set

ZADD PLACES 1 "The Clift Royal Sonesta Hotel"

Now, I want to make a case insensitive search on word "Royal". I use ZSCAN for this as below:

ZSCAN LOCATION_TRENDING 0 MATCH "*royal*" COUNT 10

ZSCAN works when I make search with "Royal" (letter R capital) but not with "royal" (letter r small).

How to make case insensitive ZSCAN match? Please guide. Thanks.

question from:https://stackoverflow.com/questions/65832452/redis-zscan-match-case-insensitive-search

Answer 1

It isn't possible to scan case insensitive. Like a workaround, you can duplicate your data with different keys and transform it to lowercase before storing.

Also, you can look through RedisSearch module if you need a complex search.