MySQL In query with Array

Question

This is my status code array = [1,2,3,4,5], and in my Claim table status_code is there. In that I store status code. Now I want find those Claim that have status code [1,2,4]. Then How can I find.

I write this query : Claim.where("status_code IN (1,2)") that workings but I need to pass array. So How can I pass array in 'In' query.

Thanks For Help.

You can see the generated SQL: Claim.where(status_code: [1,2,3]).to_sql || Another tip: Claim.where(status_code: 1..5) — MrYoshiji
– MrYoshiji, Commented Apr 7, 2014 at 17:59

Hardik · Accepted Answer · 2014-04-07 18:08:39Z

2

Assuming status_code is integer type. You can directly use the array in where clause.

array = [1,2,3,4,5]
Claim.where(status_code: array)

OR

array = [1,2,3,4,5]
Claim.where('claims.status_code IN (?)', array)

answered Apr 7, 2014 at 18:08

Hardik

3,9053 gold badges37 silver badges45 bronze badges

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

1 Comment

fatfrog Over a year ago

Why is it that you can't just put the array directly in the query?

Collectives™ on Stack Overflow

MySQL In query with Array

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