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.
BIT_OR(expr)
SELECT 1|3|5, BIT_OR(id) FROM bit_tbl WHERE id in(1,3,5);
1|3|5 bit_or(id)
============================================
7 7