Forum Multiple Where in Command

posted 9 years ago

Eloquent

Last updated 2 years ago.

replied 9 years ago

Solution

You have several options to use multiple 'where';

Chain

$members = Member::where('col1', '=', 1)->where('col2', '=', 2)->where('col3', '=', 3)->get();

Multiple calls

$query = Member::where('col1', '=', 1);
$query->where('col2', '=', 2);
$query->where('col3', '=', 3);
$members = $query->get();

Array

$members = Member::where(['col1' => 1, 'col2' => 2, 'col3' => 3])->get();

Last updated 9 years ago.

mbsmi mbsmi Joined 21 Nov 2014

We'd like to thank these amazing companies for supporting us

The Laravel portal for problem solving, knowledge sharing and community building.

Laravel.io

Socials

The community