XOR
This page is part of MariaDB's Enterprise Documentation.
The parent of this page is: SQL Operators
Topics on this page:
Overview
Logical Exclusive Or operator. Evaluates to 1 if an one operands is non-zero, zero if both are non-zero, NULL if either is NULL.
See also: SQL Operators in 10.6 ES, in 10.6 CS, in 10.5 ES, in 10.5 CS, in 10.4 ES, in 10.4 CS, in 10.3 ES, in 10.3 CS, in 10.2 ES, and in 10.2 CS
EXAMPLES
SELECT TRUE XOR TRUE, FALSE XOR FALSE;
+---------------+-----------------+
| TRUE XOR TRUE | FALSE XOR FALSE |
+---------------+-----------------+
| 0 | 0 |
+---------------+-----------------+
SELECT TRUE XOR FALSE, FALSE XOR TRUE;
+----------------+----------------+
| TRUE XOR FALSE | FALSE XOR TRUE |
+----------------+----------------+
| 1 | 1 |
+----------------+----------------+
SELECT 7 XOR 0, 0 XOR 7, 5 XOR 7;
+---------+---------+---------+
| 7 XOR 0 | 0 XOR 7 | 5 XOR 7 |
+---------+---------+---------+
| 1 | 1 | 0 |
+---------+---------+---------+
CHANGE HISTORY
Release Series | History |
---|---|
10.6 Enterprise |
|
10.6 Community |
|
10.5 Enterprise |
|
10.5 Community |
|
10.4 Enterprise |
|
10.4 Community |
|
10.3 Enterprise |
|
10.3 Community |
|
10.2 Enterprise |
|
10.2 Community |
|
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.
Information specific to MariaDB SkySQL can be found on the XOR page in the SkySQL Documentation.