mysql in query for checkbox values in database

I have stored values of checkbox in database in one field comma separated . like animals column has dogs;cats;elephants . This is in a text field.

How can i use in filter for this in mysql. i.e. select * from animaltable where animals in(cats) ;