mysql - How can I search within a table of comma-separated values?

Question

I have a MySQL table which contains comma-separated values like this:

first row=(3,56,78,12)  
second row=(6,44,2,3)  
third row=(67,4,2,7,1)  
fourth row=(88,55,22,33)  
fifth row=(88,55,3,1,5)

I want to select the rows which have 3 in their set. How can I do this?

Answer 1

Try:

SELECT * FROM TABLE_NAME WHERE FIND_IN_SET( 3, COLUMN_NAME )