YII2中andwhere如何多個or查詢
使用多個or的復雜查詢:
AND?((`name`='張三')?OR?(`name`='李四')?OR?(`name`='王五'))
//?AND?((`name`='張三')?OR?(`name`='李四')?OR?(`name`='王五')) $query->andWhere(['or', ????['name'?=>?'張三'], ????['name'?=>?'李四'], ????['name'?=>?'王五'] ]);
AND?(((name=‘張三’)?AND?(phone=‘15200000000’))?OR?((name=‘李四’)?AND?(phone=‘15300000000’)))
//?AND?(((`name`='張三')?AND?(`phone`='15200000000'))?OR?((`name`='李四')?AND?(`phone`='15300000000'))) $query->andWhere(['or', ????['and', ????????['name'?=>?'張三'], ????????['phone'?=>?'15200000000'] ????], ????['and', ????????['name'?=>?'李四'], ????????['phone'?=>?'15300000000'] ????] ]);
推薦:《YII教程》??
? 版權聲明
文章版權歸作者所有,未經允許請勿轉載。
THE END