DB::table(..)->select(..)->whereNotIn('book_price', [100,200])->get();
$query = DB::table('users'); foreach($names as $name){ $query->orWhere('name', 'LIKE', $name.'%'); } $result = $query->get();