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

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

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

Use FIND_IN_SET() function.