Finds all rows whose value in the stated column
matches the supplied pattern
(case sensitive).
The column to filter on.
The pattern to match with.
supabase.from("cities").select(columns = Columns.list("name")) {
filter {
City::name like "%la%"
//or
like("name", "%la%")
}
}
val toUpdate = City(name = "Mordor")
supabase.from("cities").update(toUpdate) {
filter {
City::name like "%la%"
//or
like("name", "%la%")
}
}
supabase.from("cities").delete {
filter {
City::name like "%la%"
//or
like("name", "%la%")
}
}
supabase.postgrest.rpc("echo_all_cities") {
filter {
City::name like "%la%"
//or
like("name", "%la%")
}
}