gorm-高级查询-组查询-where中嵌套where与or 。注意jinzuOrm，不支持。
12 / 0 / 创建于 2年前 /
wangchunbo 的个人博客
原文档
gorm.io/docs/advanced_query.html#g...
Group Conditions
Easier to write complicated SQL query with Group Conditions
db.Where(
db.Where("pizza = ?", "pepperoni").Where(db.Where("size = ?", "small").Or("size = ?", "medium")),
).Or(
db.Where("pizza = ?", "hawaiian").Where("size = ?", "xlarge"),
).Find(&Pizza{}).Statement打印结果
// SELECT * FROM `pizzas` WHERE (pizza = "pepperoni" AND (size = "small" OR size = "medium")) OR (pizza = "hawaiian" AND size = "xlarge")
本作品采用《CC 协议》，转载必须注明作者和本文链接
关于 LearnKu
粤公网安备 44030502004330号