laravel db select pluck code example

Example 1: laravel not in query

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

Example 2: pluck laravel

$name = DB::table('users')->where('name', 'John')->pluck('name');

Example 3: laravel query builder select first

$user = DB::table('users')->where('name', 'John')->first();

var_dump($user->name);

Example 4: laravel pluck

$users = Users::pluck('name','email');
dd($users);