Golang use array values in db query to filter records

Question

I have list of array int64 values

ids = [{1} {2} {3}]

I want to use the above array in db query to filter out the records where ID is not in above ids.

SELECT * from table where id not in (1,2,3);

I tried many ways to do but failing to make the query string.

Can you provide an example of how you trying to solve the problem? and provide a valid syntax like ids := []int{1,2,3} — Manjeet Singh
– Manjeet Singh, Commented Dec 6, 2021 at 8:42

Ashutosh Singh · Accepted Answer · 2021-12-06 09:03:19Z

1

I have created a sample scenario as follows :

func main() {
    ids := []int{1, 2, 3}

    var tmp []string

    for _, v := range ids {
        tmp = append(tmp, fmt.Sprint(v))
    }

    query := "SELECT * from table where id not in (" + strings.Join(tmp, ",") + ")"
    fmt.Println(query)

}

OR

You can run it in go playground link

answered Dec 6, 2021 at 9:03

Ashutosh Singh

1,1226 silver badges8 bronze badges

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

Collectives™ on Stack Overflow

Golang use array values in db query to filter records

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related