NULL查询
WhereIsNull()
可通过链式调用的方式来指定多条件的查询
- @param
field字段名
WhereIsNull()
var user []User
err := tg.Db("user").Where("age", "=", 10).WhereIsNull("score").Select(&user)var user []User
err := tg.Db("user").Where("age", "=", 10).WhereIsNull("score").Select(&user)最终的SQL语句为：
SELECT * FROM user WHERE age = 10 AND score IS NULLSELECT * FROM user WHERE age = 10 AND score IS NULL