help in select ... where ...like...

[Yashaswini P]

Hi,

I have a table with field1 values like,


1,3,5,2,3,11
3,5,6,1,5,6
2,11,3,4,1,7
7,9,11,3,6,3


Now I want the rows which consists the number 1.

If I use the query

select * from table where field1 like '%1%'

I am also getting results which are having 11 and not having 1

Please help me.