MySQLAggregate FunctionsBIT_OR
BIT_AND

BIT_ORAggregate Functions

BIT_XOR

Returns the bitwise OR aggregate.

Syntax

BIT_OR(expr)

Example

Enter values below to update the example in real time.

permission_flags
all_permissions
user_roles
user_id
SELECT BIT_OR(permission_flags) AS all_permissions
FROM user_roles
WHERE user_id = 42;