I know that for string array []string
I can use strings.Join(a []string, ',')
but I want to do the same thing for an integer array []int
.
My usecase is something like this for a query where variants
is []map[string]int
var Ids []int
sqlStr := "select id from mapping where my_id in ("
for _, mp := range variants {
sqlStr += "?,"
Ids = append(Ids, mp["id"])
}
sqlStr = strings.TrimRight(sqlStr, ",")
rows, err := db.Query(sqlStr+")", strings.Join(Ids, ',')) // I can't do this because Join needs String array
How to achieve this?