Laravel 支持Advanced Where Clauses https://laravel.com/docs/5.2/queries#advanced-where-clauses像这样:
$items = UserItems::join('items','items.id','=','user_items.item_id')
->where('user_id','=',$this->id)
->where('quantity','>',0)
->where(function($query) {
$query->where('items.type',"stones")
->orWhere('items.type',"fish");
})
->get();
我想另一个选择(更干净,更容易阅读IMO),而不是使用orWhere
,可以使用whereIn操作员 https://laravel.com/docs/5.2/queries#where-clauses like:
$items = UserItems::join('items','items.id','=','user_items.item_id')
->where('user_id','=',$this->id)
->where('quantity','>',0)
->whereIn('items.type', ["stones", "fish"])
->get();