AS
$partip_arr = explode(" ",mb_strtolower($request->keywords));
$events = Event::where('name', 'like', '%' . $request->keywords . '%')
->orWhere('description', 'like', '%' . $request->keywords . '%')
->orWhere(function($q) use ($partip_arr) {
$q->where('participants', '@>', json_encode($partip_arr[0]));
foreach ($partip_arr as $index => $value) {
if ($index === 0) {
continue;
}
$q->orWhere('participants', '@>', json_encode($value));
}
})
->offset(request('offset'))
->take(20)
->latest()->get();