查询构建器:

DB::table(..)->select(..)->whereNotIn('book_price', [100,200])->get();

口才:

SomeModel::select(..)->whereNotIn('book_price', [100,200])->get();

或者试着在laravel里拔一下 在这里

DB::table('user')                 
          ->select('id','name')
          ->whereNotIn('id', DB::table('curses')->where('id_user', '=', $id)->pluck('user_id'))
          ->get();  

查询构建器:

DB::table(..)->select(..)->whereNotIn('book_price', [100,200])->get();

口才:

SomeModel::select(..)->whereNotIn('book_price', [100,200])->get();

查询构建器:

    DB::table('book_mast')
->select('book_name','dt_of_pub','pub_lang','no_page','book_price')
    ->whereNotIn('book_price', [100,200])->get();

口才:

BookMast::select('book_name','dt_of_pub','pub_lang','no_page','book_price')
->whereNotIn('book_price', [100,200])->get();

它只是意味着你有一个值的数组，你想记录除了values/records。

你可以简单地传递一个数组到whereNotIn() laravel函数。

使用查询生成器

$users = DB::table('applications')
                    ->whereNotIn('id', [1,3,5]) 
                    ->get(); //will return without applications which contain this id's

有说服力的。

$result = ModelClassName::select('your_column_name')->whereNotIn('your_column_name', ['satatus1', 'satatus2']); //return without application which contain this status.

实现whereNotIn的动态方式:

 $users = User::where('status',0)->get();
    foreach ($users as $user) {
                $data[] = $user->id;
            }
    $available = User::orderBy('name', 'DEC')->whereNotIn('id', $data)->get();