github.com/gogf/gf@v1.16.9/.example/database/gdb/mysql/gdb_args_slice.go (about)

     1  package main
     2  
     3  import (
     4  	"github.com/gogf/gf/frame/g"
     5  )
     6  
     7  func main() {
     8  	db := g.DB()
     9  
    10  	db.Table("user").Where("nickname like ? and passport like ?", g.Slice{"T3", "t3"}).OrderBy("id asc").All()
    11  
    12  	conditions := g.Map{
    13  		"nickname like ?":    "%T%",
    14  		"id between ? and ?": g.Slice{1, 3},
    15  		"id >= ?":            1,
    16  		"create_time > ?":    0,
    17  		"id in(?)":           g.Slice{1, 2, 3},
    18  	}
    19  	db.Table("user").Where(conditions).OrderBy("id asc").All()
    20  
    21  	var params []interface{}
    22  	db.Table("user").Where("1=1", params).OrderBy("id asc").All()
    23  }