Dart Reference v2.0

Column matches a case-insensitive pattern

Finds all rows whose value in the stated column matches the supplied pattern (case insensitive).

Parameters
    column
    REQUIRED
    String

    The column to filter on.

    pattern
    REQUIRED
    String

    The pattern to match with.


final data = await supabase
  .from('countries')
  .select()
  .ilike('name', '%alba%');