Flutter: Column matches a case-insensitive pattern

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

Parameters

• column

  (Required)

  The column to filter on.

• pattern

  (Required)

  The pattern to match with.

Examples

With `select()`

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