Match at least one filter
Match only rows which satisfy at least one of the filters.
or() expects you to use the raw PostgREST syntax for the filter names and values.
.or('id.in.(5,6,7), arraycol.cs.{"a","b"}') // Use `()` for `in` filter, `{}` for array values and `cs` for `contains()`. .or('id.in.(5,6,7), arraycol.cd.{"a","b"}') // Use `cd` for `containedBy()`
Parameters
- filtersREQUIREDstring
The filters to use, following PostgREST syntax
- foreignTableOptionalobject
Set this to filter on foreign tables instead of the current table
foreignTableOptionalstring
const { data, error } = await supabase
.from('countries')
.select('name')
.or('id.eq.2,name.eq.Algeria')