ORDER BY not working in prepared stataments

[labkode]

I tried to run this sql command, the query uses the limit and offser but bypass the orderBy.
In the other hand, If I wrote the query manually (SELECT * FROM partner ORDER BY id DESC) works perfectly

    // The inputs I recive are of this type orderBy string, limit, offset int64
    query := "SELECT * FROM partner ORDER BY ? LIMIT ? OFFSET ?"
    stmt, err := db.Prepare(query)
    if err != nil {
        return
    }
    defer stmt.Close()
    rows, err := stmt.Query(orderBy, limit, offset)

[xaprb]

This isn't related to this driver, Go, or database/sql. I suggest trying to run those queries from the terminal directly. As far as I recall, the LIMIT and OFFSET parameters cannot be parameters, they must be literals that are inserted directly into the query.

[julienschmidt]

Within prepared statements, LIMIT parameters can be specified using ? placeholder markers.

http://dev.mysql.com/doc/refman/5.7/en/select.html
Since OFFSET is part of the LIMIT clause, the placeholder there is probably also fine.

But I think placeholders my not be used as an aggregate (GROUP BY) function parameter. I can not find a statement on this in the MySQL docs, but it would make a lot of sense when taking into account how aggregate functions are usually implemented.