Is there a way to select a value from a column that has commas?

I was wondering if there was a way to select from a column that has separated comma values.

For example, the column has this data: (’16’, ’20’, ’27’, ‘2’, ‘3’)

Is it possible to do something like this:

— get value 16 from table select from table where value = ’16’ or maybe use in? select from table where value in ’16’