BIT_AND()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Xpand
Topics on this page:
Overview
Returns a bitwise "and" operation across a set of aggregated numbers.
USAGE
BIT_AND(number)
Argument Name | Description |
|---|---|
| The number to "and" into the aggregated value |
DETAILS
BIT_AND() is an aggregate function that returns the bitwise "and" of a set of values.
The value is computed with 64-bit (BIGINT) precision.
A string input value is parsed into an integer, with only digits at the start of the string being significant. If there are no leading digits, it is processed as a 0 value.
A NULL input value is ignored, just as if the row didn't exist.
If no numeric values are in the input set, a 64-bit value with all bits set to 1 is returned.
EXAMPLES
CREATE TABLE bit_and_example (
item VARCHAR(20),
val INT
);
INSERT INTO bit_and_example VALUES
('Foo', 242),
('Bar', 101),
('Baz', 99),
('Foo', 113),
('Bar', 64),
('Baz', 86);
SELECT BIT_AND(val)
FROM bit_and_example;
+--------------+
| BIT_AND(val) |
+--------------+
| 64 |
+--------------+
SELECT item, BIT_AND(val)
FROM bit_and_example
GROUP BY item
ORDER BY item;
+------+--------------+
| item | BIT_AND(val) |
+------+--------------+
| Bar | 64 |
| Baz | 66 |
| Foo | 112 |
+------+--------------+