How to transform to lowercase a value in SQLite?

Question

In the SQLite database, I have stored all values in uppercase.

How can I select the specified value in the database using lower case?

Answer 1

For anyone else that arrived here from Google looking how to select as upper case in SQLite, as expected, this will work:

sqlite> SELECT UPPER("Hello, WORLD!");
HELLO, WORLD!

https://sqlite.org/lang_corefunc.html#upper

Answer 2

SQLite has a LOWER function for this:

sqlite> SELECT LOWER("Hello, WORLD!");
hello, world!

The lower(X) function returns a copy of string X with all ASCII characters converted to lower case. The default built-in lower() function works for ASCII characters only. To do case conversions on non-ASCII characters, load the ICU extension.