Kotlin: 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()`

supabase.from("cities").select(columns = Columns.list("name")) {
    filter {
       City::name ilike "%la%"
       //or
       ilike("name", "%la%")
    }
}

With `update()`

val toUpdate = City(name = "Mordor")
supabase.from("cities").update(toUpdate) {
    filter {
       City::name ilike "%la%"
       //or
       ilike("name", "%la%")
    }
}

With `delete()`

supabase.from("cities").delete {
    filter {
       City::name ilike "%la%"
       //or
       ilike("name", "%la%")
    }
}

With `rpc()`

supabase.postgrest.rpc("echo_all_cities") {
    filter {
       City::name ilike "%la%"
       //or
       ilike("name", "%la%")
    }
}