Column matches a pattern
Finds all rows whose value in the stated column
matches the supplied
pattern
(case sensitive).
Parameters
column
REQUIRED
objectThe column to filter on.
pattern
REQUIRED
stringThe pattern to filter with.
const { data, error } = await supabase
.from('cities')
.select('name, country_id')
.like('name', '%la%')