SELECT
SELECT
column_1, column_2, … FROM
table_name;
参考:
データの取得 (SELECT 文) | SQLite入門 (www.dbonline.jp)
SELECT | SQLite Query Language [Official]
WHERE
SELECT
column_1, column_2, … FROM
table_name WHERE
条件式;
select * from users where city = 'Tokyo';
select * from users where age >= 20;
参考: