$users = DB::select('select * from users '); how to echo specific item in laravel DB code example

Example: DB::table('users')->get();

DB::select('SELECT * FROM users WHERE name = ?', array(Input::get('name')));