tp5 查询某个值是否在数据表某一个字段中 FIND_IN_SET

$list = $this->model
            ->where('FIND_IN_SET(:id,members)', ['id' => $member_id])
            ->field('id,title,image,tips,collection,members')
            ->order('createtime desc')->select();

 

 

判断不在字段中  !FIND_IN_SET

$list = $this->model
            ->where('!FIND_IN_SET(:id,members)', ['id' => $member_id])
            ->field('id,title,image,tips,collection,members')
            ->order('createtime desc')->select();