mysql string searching algorithm query help

i have a string table in my mysql/php table.\[code\] id | str 3 | 2,4,5,6 4 | 7,8,9,14 5 | 3,1,16\[/code\]if i search with LIKE keyword for example "1" the result is below and its wrong\[code\] id | str 4 | 7,8,9,14 5 | 3,1,16\[/code\]But the expected result is \[code\] id | str 5 | 3,1,16\[/code\]since "1" is only in the above row but unfortunately no idea,help me with this,Nithish.
 
Back
Top