I have a table named logs.
it has sender,receivers fields.
my sample data from my table
id sender receivers
1 1 2,3
2 2 3
3 1 3,2
when i execute the below query
“select * FROM logs where sender = 1 and receiver IN (2)”
i get only one record .the id is 1.
In my table the 3rd row also has 2 in the receivers field.
but my query gives me only one receord.
if my self done wrong, kindly give any ideas to solve my issue
Thanks for your time.