SQLite string contains other string query

Question

How do I do this?

For example, if my column is "cats, dogs, birds" and I want to get any rows where a column contains cats?

Answer 1

Try using LIKE this way:

SELECT *

  FROM TABLE

 WHERE column LIKE '%cats%'  --case-insensitive