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

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

DB::select('SELECT * FROM users WHERE name = "'.Input::get('name').'"');

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

$users = DB::table('users')where('id','=', $userid)->get();

DB::table('users')->where('name', Input::get('name'))->get();

DB::select('select * from users ');

$query = DB::table('users');

foreach($names as $name){
    $query->orWhere('name', 'LIKE', $name.'%');
}

$result = $query->get();