XOR

Description

Logical XOR. Returns NULL if either operand is NULL. For non-NULL operands, evaluates to true if an odd number of operands is nonzero, otherwise false is returned.

a XOR b is mathematically equal to (a AND (NOT b)) OR ((NOT a) and b).

Syntax

  1. > SELECT column_1 XOR column_2 FROM table_name;

Examples

  1. mysql> select 1 xor 1;
  2. +---------+
  3. | 1 xor 1 |
  4. +---------+
  5. | false   |
  6. +---------+
  7. 1 row in set (0.01 sec)
  9. mysql> select 1 xor 0;
  10. +---------+
  11. | 1 xor 0 |
  12. +---------+
  13. | true    |
  14. +---------+
  15. 1 row in set (0.00 sec)
  17. mysql> select 1 xor null;
  18. +------------+
  19. | 1 xor null |
  20. +------------+
  21. | NULL       |
  22. +------------+
  23. 1 row in set (0.01 sec)
  25. mysql> select 1 xor 1 xor 1;
  26. +---------------+
  27. | 1 xor 1 xor 1 |
  28. +---------------+
  29. | true          |
  30. +---------------+
  31. 1 row in set (0.00 sec)
  1. create table t1 (a boolean,b bool);
  2. insert into t1 values (0,1),(true,false),(true,1),(0,false),(NULL,NULL);
  4. mysql> select a xor b from t1;
  5. +---------+
  6. | a xor b |
  7. +---------+
  8. | true    |
  9. | true    |
  10. | false   |
  11. | false   |
  12. | NULL    |
  13. +---------+
  14. 5 rows in set (0.00 sec)