Javascript Reference v2.0

Column matches a case-insensitive pattern

Match only rows where column matches pattern case-insensitively.

Parameters
    column
    REQUIRED
    string

    The column to filter on

    pattern
    REQUIRED
    string

    The pattern to match with


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