search by full name laravel in query builder code example

Example 1: laravel where like

$users = DB::table('users')
                ->where('name', 'like', 'T%')
                ->get();

Example 2: laravel wher in

$users = DB::table('users')
                    ->whereIn('id', [1, 2, 3])
                    ->get();