SQLite string contains other string query

November 23, 2022 by Tarik

Using LIKE:

SELECT *
  FROM TABLE
 WHERE column LIKE '%cats%'  --case-insensitive