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('characters')
  .select()
  .ilike('name', '%lu%')