How to make an SQL query in golang with multiple values in the WHERE clause

Question

I am trying to perform the following type of query in golang using the sql library:

    rows, err := db.Query("select * from someTable where age = ? and hairColor = ?", age,haircolor)

But get the following sort of error:

    Error occured: sql: expected 1 arguments, got 2

How do I perform an SQL select statement in golang where there are multiple values in the WHERE clause?

which db are you using?

leaf bebop
– leaf bebop

2019-11-23 08:25:34 +00:00
Commented Nov 23, 2019 at 8:25 — leaf bebop
– leaf bebop, Commented Nov 23, 2019 at 8:25
database/sql and mysql.

Ryan McDermott
– Ryan McDermott

2019-12-17 05:09:34 +00:00
Commented Dec 17, 2019 at 5:09 — Ryan McDermott
– Ryan McDermott, Commented Dec 17, 2019 at 5:09

Ryan McDermott · Accepted Answer · 2019-11-23 06:31:04Z

3

The answer is to use a prepared statement so in my example here:

stmt, err := db.Prepare("select * from someTable where age = ? and hairColor = ?")
rows, err := stmt.Query(age,hairColor)

This seems obvious in retrospect. Hopefully this can save somebody a few minutes of hair pulling in the future!

answered Nov 23, 2019 at 6:31

Ryan McDermott

5711 gold badge5 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

mkopriva Over a year ago

This doesn't seem obvious, not even in retrospect. Anyways, it should not be necessary to use Prepare just to be able to pass more than one argument. Either the original error you got is not from the query+args that you've showed, or you're using some broken/unconventional driver.

Collectives™ on Stack Overflow

How to make an SQL query in golang with multiple values in the WHERE clause

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related