Case insensitive in SQLite

sql, sqlite

Solution

How about

SELECT id,name 
FROM trait 
WHERE UPPER(name) IN ("RATIO")

Problem

I need to select some rows in SQLite with case insensitive string. For example: COLLATE NOCASE is working for "=", e.g. ``` SELECT id,name from trait WHERE name = "ratio" COLLATE NOCASE ``` But is not working for "in", e.g. ``` SELECT id,name from trait WHERE name in ("ratio") COLLATE NOCASE ``` I have to use "in" to select multiple values, e.g. ``` SELECT id,name from trait WHERE name in ("ratio", 'number') COLLATE NOCASE ``` How should I change my SQL script? Thanks for any suggestions.

Original source