ilike method

PostgrestFilterBuilder<T> ilike(
  1. String column,
  2. String pattern
)

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

await supabase
    .from('users')
    .select()
    .ilike('username', '%SUPA%');

Implementation

PostgrestFilterBuilder<T> ilike(String column, String pattern) {
  return copyWithUrl(appendSearchParams(column, 'ilike.$pattern'));
}