I am very new to SQLite and still learning. I have imported a csv file called 'CATALOGUE.csv' to a table called 'ctl' and running a query to filter the column 'partner_sku' for strings of certain pattern as below; SELECT partner_sku FROM ctl WHERE partner_sku LIKE 'A1012%' OR partner_sku LIKE 'A207%' OR partner_sku LIKE 'KH108%'; For few number of criteria in this query is alright, but as number grows it looks mess to handle. I read about WHERE with IN CLAUSE but don't know how to incorporate that here. Need your kind help.