Joren Joren - 2 years ago 444
SQL Question

SQLite string contains other string query

How do I do this?

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

Answer Source

Using LIKE:

 WHERE column LIKE '%cats%'
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download