Laravel - Query Builder - Specifying A Select Clause

You may not always want to select all columns from a database table. Using the select method, you can specify a custom "select" clause for the query:

    use Illuminate\Support\Facades\DB;
    $users = DB::table('users')
                ->select('name', 'email as user_email')

The distinct method allows you to force the query to return distinct results:

    $users = DB::table('users')->distinct()->get();

If you already have a query builder instance and you wish to add a column to its existing select clause, you may use the addSelect method:

    $query = DB::table('users')->select('name');
    $users = $query->addSelect('age')->get();