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?
Using LIKE:
SELECT * FROM TABLE WHERE column LIKE '%cats%'