MySQL
keyboard_arrow_down 295 guides
chevron_leftOperators
check_circle
Mark as learned thumb_up
0
thumb_down
0
chat_bubble_outline
0
Comment auto_stories Bi-column layout
settings
MySQL | XOR
schedule Aug 12, 2023
Last updated local_offer
Tags MySQL
tocTable of Contents
expand_more Master the mathematics behind data science with 100+ top-tier guides
Start your free 7-days trial now!
Start your free 7-days trial now!
MySQL's XOR operator returns 1 if an odd number of operands is nonzero or 0 if an even number of operands is nonzero. If either operand is NULL we return NULL.
Syntax
SELECT value1 XOR value2 XOR value3;
Examples
Odd nonzero operands
To check whether we have an odd number of nonzero operands:
SELECT 3 XOR 4 XOR 5;
+---------------+| 3 XOR 4 XOR 5 |+---------------+| 1 |+---------------+
As we have 3 non-zero operands, 1 is returned.
Even nonzero operands
To check whether we have an odd number of nonzero operands:
SELECT 3 XOR 4;
+---------+| 3 XOR 4 |+---------+| 0 |+---------+
As we have 2 nonzero operands, 0 is returned.
NULL operand
To check whether we have an odd number of nonzero operands:
SELECT 1 XOR NULL;
+------------+| 1 XOR NULL |+------------+| NULL |+------------+
As one of the operands is NULL, NULL is returned.
Published by Arthur Yanagisawa
Edited by 0 others
Did you find this page useful?
thumb_up
thumb_down
Comment
Citation
Ask a question or leave a feedback...
Official MySQL Documentation
https://dev.mysql.com/doc/refman/8.0/en/logical-operators.html#operator_xor
thumb_up
0
thumb_down
0
chat_bubble_outline
0
settings
Enjoy our search
Hit / to insta-search docs and recipes!
