BOOL_OR

Returns true if any non NULL input value is true, otherwise false. If all input values are NULL values, returns NULL.

Syntax

BOOL_OR(<expression>) [FILTER ([WHERE] <condition>)]

Parameter	Description	Supported input types
`<expression>`	The boolean expression used to calculate the result	`BOOLEAN`
`<condition>`	An optional boolean expression to filter rows used in aggregation	`BOOL`

BOOLEAN

The following query shows the tournaments with the highest prize amounts in the tournaments table:

SELECT name, totalprizedollars FROM tournaments ORDER BY totalprizedollars DESC LIMIT 5;

Rows: 5Execution time: 6.00ms

The following example checks whether any tournament in the tournaments table has a prize of more than 20,000:

SELECT BOOL_OR(totalprizedollars > 20000) AS has_big_prize FROM tournaments;

has_big_prize boolean null
True

Rows: 1Execution time: 5.78ms

⌘I