But, here i have one column 'deleted_by_org' which store data as in format [1,2,5].
You mean the deleted_by_org column literally has [1,2,5] as the value? I sure hope not...
Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
Currently, I am using serverside jquery data table. So, here is the snippet for it.
if(empty($request->input('search.value'))){
$posts = Base_voter::offset($start)
->limit($limit)
->orderBy($order,$dir)
->get();
$totalFiltered = Base_voter::count();
}else{
$search = $request->input('search.value');
$posts = Base_voter::where('name_voter', 'like', "%{$search}%")
->orWhere('name_first','like',"%{$search}%")
->orWhere('name_last','like',"%{$search}%")
->orWhere('home_street_address_1','like',"%{$search}%")
->orWhere('mailing_street_address_1','like',"%{$search}%")
->orWhere('home_address_city','like',"%{$search}%")
->orWhere('mailing_address_city','like',"%{$search}%")
->offset($start)
->limit($limit)
->orderBy($order, $dir)
->get();
$totalFiltered = Base_voter::where('name_voter', 'like', "%{$search}%")
->orWhere('name_first','like',"%{$search}%")
->orWhere('name_last','like',"%{$search}%")
->orWhere('home_street_address_1','like',"%{$search}%")
->orWhere('mailing_street_address_1','like',"%{$search}%")
->orWhere('home_address_city','like',"%{$search}%")
->orWhere('mailing_address_city','like',"%{$search}%")
->count();
}
But, here i have one column 'deleted_by_org' which store data as in format [1,2,5]. Now, I want to get only those records which is equivalent to where !in_array($org_id,[1,2,5]).
That means, don't fetch this record, if $org_id = 1 or 2 or 5.
Please or to participate in this conversation.