【Laravel5】Model Where条件の使い方

whereで指定

Model::where('id', '1')->get();

Model::where('id', '1')->where('name', 'hoge')->get();

where OR で指定

Model::where('id', '1')->orWhere('id', '2')->get();

スポンサーリンク

不等号 と こんな指定の仕方も出来る例

Model::where('age', '>', '23')->where('id', '1')->orWhere('id', '2')->get();

whereRawで指定&order

Model::whereRaw('create_at >= ? and create_at <= ?', array($data['create_at_from'], $data['create_at_to']))->orderBy('create_at','ASC')->get();

like

$param = 'keyword'; Model::where('title', 'like', "%{$param}%")->get();

in

Model::whereIn('id', [2])->get(); Model::whereNotIn('id', [2])->get();

Model::whereIn('id', [2,3,4,5])->get(); Model::whereNotIn('id', [2,3,4,5])->get();

Where カラム名

Model::whereTitle('keyword')->get();