Column matches a case-insensitive pattern
Match only rows where column
matches pattern
case-insensitively.
Parameters
column
REQUIRED
stringThe column to filter on
pattern
REQUIRED
stringThe pattern to match with
const { data, error } = await supabase
.from('countries')
.select()
.ilike('name', '%alba%')