Home

Column matches a case-insensitive pattern

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


final res = await supabase
  .from('cities')
  .select('name, country_id')
  .ilike('name', '%la%')
  .execute();
Need some help?

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