条件查询
=
db.Where("name = ?", "jinzhu").First(&user)
<>(不等于)
db.Where("name <> ?", "jinzhu").Find(&users)
IN
db.Where("name IN ?", []string{"jinzhu", "jinzhu 2"}).Find(&users)
LIKE
<ol><li>db.Where(&quot;name LIKE ?&quot;, &quot;%jin%&quot;).Find(&users)</li></ol>
AND
db.Where(&quot;name = ? AND age &gt;= ?&quot;, &quot;jinzhu&quot;, &quot;22&quot;).Find(&users)
TIME
db.Where(&quot;updated_at &gt; ?&quot;, lastWeek).Find(&users)
BETWEEN
db.Where(&quot;created_at BETWEEN ? AND ?&quot;, lastWeek, today).Find(&users)
用Struct或Map作为条件来查询
注意：当使用结构作为条件查询时，GORM 只会查询非零值字段。这意味着如果您的字段值为 0、&apos;&apos;、false 或其他 零值，该字段不会被用于构建查询条件
NOT
db.Not(&quot;name = ?&quot;, &quot;jinzhu&quot;).First(&user)<br>
Not In
OR
db.Where().Or().Find()
查询特定字段
db.Select(&quot;name”， “age&quot;).Find(&users)
db.Select([]string{&quot;name&quot;, &quot;age&quot;}).Find(&users)
// SELECT name, age FROM users;
Limit&Offset
db.Limit(10).Offset(5).Find(&users)
// SELECT * FROM users OFFSET 5 LIMIT 10;
Group & Having
db.Model(&User{}).Select(&quot;name, sum(age) as total&quot;).Where(&quot;name LIKE ?&quot;, &quot;group%&quot;).Group(&quot;name&quot;).First(&result)
// SELECT name, sum(age) as total FROM `users` WHERE name LIKE &quot;group%&quot; GROUP BY `name`
https://learnku.com/docs/gorm/v2/query/9733#3d16eb
Distinct
db.Distinct(&quot;name&quot;, &quot;age&quot;).Order(&quot;name, age desc&quot;).Find(&results)
Joins
https://learnku.com/docs/gorm/v2/query/9733#a231f4
