Home

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%')
Need some help?

Not to worry, our specialist engineers are here to help. Submit a support ticket through the Dashboard.