How to use variable as column name?

Question

MySQL

There is a function that should check if the user has rights. If there is a right - in cell 1, if not - 0.

func checkIfGroupHasRight(db *sql.DB, groupname interface{}, privilege string) bool {
  ...
  rows, err := db.Query("SELECT ? FROM hellgate_groups WHERE groupname=?", privilege, strGroupname)
  ...
}

checkIfGroupHasRight(db, session.Values["usergroup"], "deleteuser")

I get an error when calling

error: "sql: Scan error on column index 0, name \"?\": converting driver.Value type []uint8 (\"deleteuser\") to a int: invalid syntax"

What am I doing wrong? Why is privilege (string) perceived by the driver as []uint8 and why is it trying to cast to int?

Answer 1

no way. placeholders in requests only values ​​are passed