How to select specific columns in laravel eloquent

Question

lets say I have 7 columns in table, and I want to select only two of them, something like this

SELECT `name`,`surname` FROM `table` WHERE `id` = '1';

In laravel eloquent model it may looks like this

Table::where('id', 1)->get();

but I guess this expression will select ALL columns where id equals 1, and I want only two columns(name, surname). how to select only two columns?

Answer 1

You can do it like this:

Table::select('name','surname')->where('id', 1)->get();

Answer 2

Table::where('id', 1)->get(['name','surname']);