mysql - Storing IDs as comma separated values

Question

How can I select from a database all of the rows with an ID stored in a varchar comma separated. for example, I have a table with this:

, 7, 9, 11

How can I SELECT the rows with those IDs?

Answer 1

Normalize your database. You should be using a lookup table most likely.