find record by value in array

[zzz]

I have a table one field of which stores numeric value. Sometimes it could be a comma separated string of numbers:

22,23,41

How do I retrieve results that have a given value in that cell?

I think I've done this in the past but at the moment I can't think for the world how...

[johanafm]

Fix your database design instead: http://en.wikipedia.org/wiki/Database_normalization]Normalization

tableA:
id	remove your field for numbers, keep the rest in there (assuming it doesn't break 4NF)
primary key(id)

numberTable
number	tableA_id
primary key(number, tableA_is)

[zzz]

I can't fix this, I have to work with what I've got. The string comes from elsewhere. I can match the records when when there's only one value in the field

WHERE myField = ".$myValue."

I also could've done if I had to match a value against a string

WHERE myField IN (".$myString.")

...I think I need more caffeine...

[dagon]

WHERE myField like %$myValue% 

[Roger_Ramjet]

dagon;10929878 wrote:

WHERE myField like %$myValue% 

Trouble with that is that 22 will also match 122, 225, etc. try using a Regular Expression. But really you should normalise the data.