.or()
Finds all rows satisfying at least one of the filters.
- JavaScript
const { data, error } = await supabase
.from('cities')
.select('name, country_id')
.or('id.eq.20,id.eq.30')
Parameters
filtersrequired
string
The filters to use, separated by commas.
__namedParametersrequired
object
No description provided.
foreignTablerequired
undefined
|string
The foreign table to use (if
column
is a foreign column).
Properties
Examples
select()
With - JavaScript
const { data, error } = await supabase
.from('cities')
.select('name, country_id')
.or('id.eq.20,id.eq.30')
or
with and
Use - JavaScript
const { data, error } = await supabase
.from('cities')
.select('name, country_id')
.or('id.gt.20,and(name.eq.New Zealand,name.eq.France)')
or
on foreign tables
Use - JavaScript
const { data, error } = await supabase
.from('countries')
.select('id, cities(*)')
.or('name.eq.Wellington,name.eq.Paris', { foreignTable: "cities" })