Mysql Query needed

[vssp]

hi friends

I need the query , I have stored the ids like this 4,10,12,13,14 in one filed.

I need to search the id 4 avaliable in the one filed , how to search the number one single filed?

Please advise

[pritaeas]

Can you give an example of what you are trying to achieve ?

[vssp]

in my table i have stored id like this
id name c_id
insert into (id,name,c_id)values( 1, john, 4,10,12,13,15)
Now i need seach id 10 avilable this row.how to write query,

Hope you clear

[Shanti C]

select * from table where c_id like  '% 4%';

[mwasif]

Use FIND_IN_SET() function.