Column matches a pattern
Match only rows where column
is less than or equal to value
.
Finds all rows whose value in the stated column
matches the supplied pattern
(case sensitive).
Parameters
column
REQUIRED
stringThe column to filter on
value
REQUIRED
anyThe value to filter with
final data = await supabase
.from('cities')
.select('name, country_id')
.like('name', '%la%');