[
[
'goods_id' => 1,
'attr_item' => '49,52'
], [
'goods_id' => 1,
'attr_item' => '49,51'
]
]我想查詢這樣一個(gè)條件 goods_id=1 && attr_item =="49,52 || goods_id=1 && attr_item =="49,51"這樣的多字段組成唯一性 要怎么寫呢
1 回答
回首憶惘然
TA貢獻(xiàn)1847條經(jīng)驗(yàn) 獲得超11個(gè)贊
用閉包查詢
$result = Db::table('think_user')->where(function ($query) {
$query->where('id', 1)->whereOr('id', 2);
})->whereOr(function ($query) {
$query->where('name', 'like', 'think')->whereOr('name', 'like', 'thinkphp');
})->select();生成的sql語(yǔ)句類似于下面
SELECT * FROM `think_user` WHERE ( `id` = 1 OR `id` = 2 ) OR ( `name` LIKE 'think' OR `name` LIKE 'thin
- 1 回答
- 0 關(guān)注
- 1586 瀏覽
添加回答
舉報(bào)
0/150
提交
取消