Case insensitive query both for uppercase and lowercase

Is it possible to use Where clause with case insensitive both for uppercase and lowercase?

I store names in documents like:

ASUS mouse Amazon 

How to match these names with passed name like:

asus mouse Amazon
FROM default 
WHERE LOWER(name) =  LOWER("asus mouse Amazon");

If you need you can index on LOWER(name)

1 Like