Trying to retrieve data where a variable is in an array

[webmaster]

Okay, I have a column in my MySQL table that stores the data, due to how it's received, as a comma delimited array, eg 2,5,23,28. This array is of variable length.

What I would like to do is SELECT a row from the table where that array contains a variable, eg if $variable is '3' then it would retrieve a row that has 1,3,13,18 in the array, but not one like 1,13,23. LIKE doesn't seem to be working correctly. Is there any way of doing this?