Database
Column is in an array
Match rows where a column is in a set of values.
Filter rows where column IN (...). The method is named in_ because in is a reserved keyword in Ruby's parser.
Signature
builder.in_(column, values)Parameters
| Name | Type | Required | Description |
|---|---|---|---|
column | String / Symbol | Required | Column name. |
values | Array | Required | Array of values to match against. Each element is sanitized for the PostgREST query string and joined with commas inside parentheses. |
Returns
Returns
self (FilterRequestBuilder)
The same builder for chaining.
Example — match a small set of ids
supabase
.from("countries")
.select("id, name")
.in_("id", [1, 2, 3])
.executeExample — string values
supabase
.from("orders")
.select("*")
.in_("status", ["pending", "paid", "shipped"])
.executeExample — delete many rows by primary key
supabase
.from("notifications")
.delete
.in_("id", stale_ids)
.executeWhy `in_` and not `in`
in is a reserved word in Ruby's parser, so the method is in_. PostgREST receives column=in.(v1,v2,...).