BIT_OR Function

Description

An aggregate function. It performs OR operations in bits on every bit of expr. The return value is a BIGINT type. If there is no row that satisfies the expression, NULL is returned. 

Syntax

BIT_OR(expr)

Example

SELECT 1|3|5, BIT_OR(id) FROM bit_tbl WHERE id in(1,3,5);

                 1|3|5            bit_or(id)

============================================

                     7                     7