MySQLAggregate FunctionsBIT_AND
VAR_SAMP

BIT_ANDAggregate Functions

BIT_OR

Returns the bitwise AND aggregate.

Syntax

BIT_AND(expr)

Example

Enter values below to update the example in real time.

permission_flags
common_permissions
user_roles
role_id
SELECT BIT_AND(permission_flags) AS common_permissions
FROM user_roles
WHERE role_id = 3;