Case insensitive query both for uppercase and lowercase

SQL++
1

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
2 
SELECT * 
FROM default 
WHERE LOWER(name) =  LOWER("asus mouse Amazon");

If you need you can index on LOWER(name)

1 Like