DB::table('users') ->where('name', '=', 'John') ->where(function ($query) { $query->where('votes', '>', 100) ->orWhere('title', '=', 'Admin'); }) ->get();
$users = DB::table('users') ->join('contacts', 'users.id', '=', 'contacts.user_id') ->join('orders', 'users.id', '=', 'orders.user_id') ->select('users.*', 'contacts.phone', 'orders.price') ->get();
Sometime for such queries you need to disable the strict check So inside config/database.php and inside mysql, Set 'strict' => false, ->select('user_id', DB::raw('SUM(points) as total_points'))
$users = DB::table('users') ->whereIn('id', [1, 2, 3]) ->get();
$count = DB::table('category_issue')->count();