Database query builder laravel code example
Example 1: laravel wher in
$users = DB::table('users')
->whereIn('id', [1, 2, 3])
->get();
Example 2: query builder laravel
use Illuminate\Database\Eloquent\Builder;
public function scopeFakePersons(Builder $query): Builder
{
return $query->where('is_fake', 1);
}
Example 3: laravel having
$users = DB::table('users')
->groupBy('account_id')
->having('account_id', '>', 100)
->get();