&

Bitwise AND.

Syntax

MYSQL Copy

SELECT 29 & 15;
13
SELECT HEX(_binary X'FF' & b'11110000');
'F0'

Examples

Example

The result type depends on whether the arguments are evaluated as binary strings or numbers:

MYSQL Copy

SELECT 29 & 15;
13
SELECT HEX(_binary X'FF' & b'11110000');
'F0'