Database
Column matches a case-insensitive pattern
Case-insensitive pattern match using SQL ILIKE.
Filter rows where column ILIKE pattern. Same wildcard syntax as like, but case-insensitive.
Signature
builder.ilike(column, pattern)Parameters
| Name | Type | Required | Description |
|---|---|---|---|
column | String / Symbol | Required | Column name. |
pattern | String | Required | SQL LIKE pattern. % matches any sequence, _ matches one character. Case-insensitive. |
Returns
Returns
self (FilterRequestBuilder)
The same builder for chaining.
Example — case-insensitive prefix
supabase
.from("users")
.select("id, email")
.ilike("email", "alice@%")
.execute
# Matches "alice@…", "ALICE@…", "Alice@…"Example — fuzzy substring search
supabase
.from("countries")
.select("name")
.ilike("name", "%land%")
.execute
# => [{ "name" => "England" }, { "name" => "Iceland" }, { "name" => "Poland" }, ...]Use like when case matters.