tags:

views:

45

answers:

1

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?

+1  A: 

Using LIKE:

SELECT *
  FROM TABLE
 WHERE column LIKE '%cats%'
OMG Ponies