SQLite - how to lowercase all rows of a column?

Question

SQLite

There is a sqlite3 base. It has a column called title. Each entry has lines in which the letters are in different cases. Is it possible to somehow convert all characters of this column to lowercase using an SQL query.

Answer 1

update myTable
    set title = lower(title)

By the way, this secret link was in the first line for "sqlite lower case":
https://www.w3resource.com/sqlite/core-functions-l...