use Illuminate\Support\Facades\DB; class UserController extends Controller { public function index() { $users = DB::table('users')->select('id','name','email')->get(); return view('some-view')->with('users', $users); } }
$users = DB::table('users')->get();
$query = DB::table('users'); foreach($names as $name){ $query->orWhere('name', 'LIKE', $name.'%'); } $result = $query->get();