supabase-rb-rb
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

NameTypeRequiredDescription
columnString / SymbolRequiredColumn name.
valuesArrayRequiredArray 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])
  .execute

Example — string values

supabase
  .from("orders")
  .select("*")
  .in_("status", ["pending", "paid", "shipped"])
  .execute

Example — delete many rows by primary key

supabase
  .from("notifications")
  .delete
  .in_("id", stale_ids)
  .execute

Why `in_` and not `in`

in is a reserved word in Ruby's parser, so the method is in_. PostgREST receives column=in.(v1,v2,...).

On this page