Unable to select a column on sqlite3 database

python sqlite

case is reserved keyword in SQLite.

Using double quotes in the query as mentioned in the SQLite documentation should get your query working.

Related

`strip` Python method non-obvious behavior [duplicate]
Check if correct Google Play Service available: "Unfortunately application has stopped working"
How to set opacity of background colour of graph with Matplotlib
Exception using HttpRequest.execute(): Invalid use of SingleClientConnManager: connection still allocated
/usr/lib/x86_64-linux-gnu/libstdc++.so.6: version CXXABI_1.3.8' not found
Height 100% on flexbox column child [duplicate]
Python exception chaining [duplicate]
Why use sys.path.append(path) instead of sys.path.insert(1, path)?
MySQL update CASE WHEN/THEN/ELSE [duplicate]
Colon after Constructor in dart
How to part DATE and TIME from DATETIME in MySQL
CustomPage for Serial Number in Inno Setup