How to execute an IN lookup in SQL using Golang?

by

It looks like you may be using the pq driver. pq recently added Postgres-specific Array support via pq.Array (see pull request 466). You can get what you want via:

stmt, err := db.Prepare("SELECT * FROM awesome_table WHERE id= $1 AND other_field = ANY($2)")
rows, err := stmt.Query(10, pq.Array([]string{'this','that'})

I think this generates the SQL:

SELECT * FROM awesome_table WHERE id=10 AND other_field = ANY('{"this", "that"}');

Note this utilizes prepared statements, so the inputs should be sanitized.

More Related Contents:

  1. “Operator does not exist: integer =?” when using Postgres
  2. How can I work with SQL NULL values and JSON in a good way?
  3. Sql Server Relation [closed]
  4. Get the mentioned output by SQL query
  5. Decrease salary using a SQL query
  6. Calculate a Running Total in SQL Server
  7. Reason for Column is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause [duplicate]
  8. Get top results for each group (in Oracle)
  9. ORA-12560: TNS:protocol adaptor error
  10. How to store only time; not date and time?
  11. How to fetch the row count for all tables in a SQL SERVER database [duplicate]
  12. MySQL ON DUPLICATE KEY UPDATE for multiple rows insert in single query
  13. WHERE Clause vs ON when using JOIN
  14. Using a Variable in OPENROWSET Query
  15. Find overlapping date ranges in PostgreSQL
  16. How do you do date math that ignores the year?
  17. Does MS SQL Server’s “between” include the range boundaries?
  18. basic recursive query on sqlite3?
  19. Check for file exists or not in sql server?
  20. Split one column value into multiple column values
  21. Why doesn’t SQL support “= null” instead of “is null”?
  22. T-SQL and the WHERE LIKE %Parameter% clause
  23. Know relationships between all the tables of database in SQL Server
  24. Difference between “read commited” and “repeatable read” in SQL Server
  25. SQL Oracle LEFT JOIN and SUBQUERY error: ORA-00905: missing keyword
  26. How do I create and query linked database servers in SQL Server?
  27. What is Full Text Search vs LIKE
  28. Add emoji / emoticon to SQL Server table
  29. Determine what user created objects in SQL Server
  30. Oracle: ‘= ANY()’ vs. ‘IN ()’

Leave a Comment