^
This page is part of MariaDB's Documentation.
The parent of this page is: SQL Operators for MariaDB Xpand
Topics on this page:
Overview
Bitwise exclusive "or".
USAGE
number1 ^ number2
Value Name | Description |
|---|---|
| Two numbers to combine with bitwise exclusive "or" |
DETAILS
The ^ operator returns a bitwise exclusive "or" of two numbers.
If you imagine each number in binary representation aligned by their least-significant bit, a bitwise "or" generates a 1 result bit for each pair of aligned bits that do not match each other.
The return value is the number representing the bit positions that differ in the two numbers.
A NULL is returned if either value is NULL.
EXAMPLES
SELECT 3 ^ 5, 1 ^ 3, 0 ^ 7;
+-------+-------+-------+
| 3 ^ 5 | 1 ^ 3 | 0 ^ 7 |
+-------+-------+-------+
| 6 | 2 | 7 |
+-------+-------+-------+