JavaScript: Column matches a case-insensitive pattern

Match only rows where column matches pattern case-insensitively.

Parameters

• column

  (Required)

  The column to filter on

• pattern

  (Required)

  The pattern to match with

Examples

With `select()`

const \{ data, error \} = await supabase
  .from('countries')
  .select()
  .ilike('name', '%alba%')