表task数据
实现功能:
数组:$data =Array ( [0] => 68 [1] => 69 );
receiver字段:储存了多个id以“,”分割
要把task表字段receiver储存的id要是有一个id符合$data数组的某个数据,就把task表对应数据查询出来?怎么实现?
表task数据
实现功能:
数组:$data =Array ( [0] => 68 [1] => 69 );
receiver字段:储存了多个id以“,”分割
要把task表字段receiver储存的id要是有一个id符合$data数组的某个数据,就把task表对应数据查询出来?怎么实现?
select * from task where receiver like '%,'+id+',%' or receiver like id+',%' or receiver like '%,'+id or receiver = id