xxxxxxxxxx
DB::table('table_employee')
->select('id', 'name')
->where('name', '<>', '')
xxxxxxxxxx
SomeModel::select(..)->whereNotIn('book_price', [100,200])->get();
xxxxxxxxxx
Code::where('to_be_used_by_user_id', '<>' , 2)->get()
Code::whereNotIn('to_be_used_by_user_id', [2])->get()
Code::where('to_be_used_by_user_id', 'NOT IN', 2)->get()
xxxxxxxxxx
$result = Exams::whereNotIn('id', function($q){
$q->select('examId')->from('testresults');
})->get();
xxxxxxxxxx
SomeModel::select(..)->whereNotIn('book_price', [100,200])->get();