sqlx为此提供了很好的帮助:在In()中,我们只需要使用args和Rebind准备查询,如下所示:
var qids []int// fills qids on query dynamicallyquery, args, err := sqlx.In("SELECt * FROM quote WHERe qid IN (?)", qids)if err != nil { log.Fatal(err)}// sqlx.In returns queries with the `?` bindvar, we can rebind it for our backend//query = database.SQL.Rebind(query) // database.SQL should be a *sqlx.DBerr = database.SQL.Select("es, query, args...)if err != nil { log.Fatal(err)}// or just in one line:err = database.SQL.Select("es, database.SQL.Rebind(query), args...)另外,我建议您在这里看看:http :
//jmoiron.github.io/sqlx/有很多示例,包括 IN



