数据表 一个字段里储存了多个id匹配符合条件id怎么查询？

Question

表task数据
实现功能：
数组：$data =Array ( [0] => 68 [1] => 69 );
receiver字段：储存了多个id以“，”分割

要把task表字段receiver储存的id要是有一个id符合$data数组的某个数据，就把task表对应数据查询出来？怎么实现?

Answer 1

select * from task where receiver like '%,'+id+',%' or receiver like id+',%' or receiver like '%,'+id or receiver = id