I have a MySQL problem. This is just an example just to solve my real problem. Let's say I have a table like this:

* Columns: id, name, classes.
* Classes field is comma separated value like 1,4,5,4

I know database design is wrong and very bad.

What I want to do is select `name` where class is equal to 4 whereas the classes field has value 3,4,6,3,8 in MySQL. How can I do that?