MySQL - WHERE item IN commaSeperatedColumn

Question

How do you query to a comma separated value? In a table I have a column named colors it contains color-codes like this 1,5,8.

How do i check whether, for example value 5, is within the comma separated column colors?

Is this even possible to do with MySQL?

ps: it is possible that there is a single value within the column 'colors'

Possible duplicate [http://stackoverflow.com/questions/5033047/mysql-query-finding-values-in-a-comma-separated-string](http://stackoverflow.com/questions/5033047/mysql-query-finding-values-in-a-comma-separated-string) — Il Vic, Jun 08 '15 at 14:10

score 1 · Accepted Answer · answered Jun 08 '15 at 14:09

1

You can use find_in_set('5', colors) for that.

But it is no good practice to store values as csv.

answered Jun 08 '15 at 14:09

Jens

1 Answers1