Skip to content

Instantly share code, notes, and snippets.

@raismaulana
Created September 23, 2022 06:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save raismaulana/82a92349bb429c830b60137aa6a29b42 to your computer and use it in GitHub Desktop.
Save raismaulana/82a92349bb429c830b60137aa6a29b42 to your computer and use it in GitHub Desktop.
unsafe_array_query.go
func query(db *sql.DB, name []string) {
query := fmt.Sprint("select id, name, grade from students ")
where := "where "
params := interface{}{}
if len(names) > 0 {
where += `f.id IN ('` + strings.Join(names, "','") + `') `
}
query = query + where
_, err := db.Query(query, params...)
if err != nil {
fmt.Println(err.Error())
return
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment