Laravel中的select和where子句eloquent

Im trying to get three columns of my DB, but I don't get it...

I can use this code. But this way returned all the columns, and only I want three of them.

User::where('name', 'LIKE', $term)->get()

And I know use this other code: But... in them I cannot use the "where" clausule.

User::select(array('id', 'name', 'email'))

Anybody know one way to merge the both codes? Perhaps the only way to do that is using Fluent?

So chain them together. Eloquent lets you add any number of statements together until you call one of the closures get() or first():

$users = User::select(array('id', 'name', 'email'))->where('name', 'LIKE', '%'.$term.'%')->get();

After calling the above, you can call a foreach to show all the results:

foreach($users AS $user){
  echo $user->id;
  echo $user->name;
  echo $user->email;
}

Hope that helps!