Flutter: Column matches a case-insensitive pattern

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

Examples

With `select()`

final data = await supabase
  .from('cities')
  .select('name, country_id')
  .ilike('name', '%la%');

With `update()`

final data = await supabase
  .from('cities')
  .update(\{ 'name': 'Mordor' \})
  .ilike('name', '%la%');

With `delete()`

final data = await supabase
  .from('cities')
  .delete()
  .ilike('name', '%la%');

With `rpc()`

// Only valid if the Stored Procedure returns a table type.
final data = await supabase
  .rpc('echo_all_cities')
  .ilike('name', '%la%');