Uses the bitwise XOR (^) operator to manipulate the bit values. : XOR « Function « SQL / MySQL

1. SQL / MySQL
2. Function
3. XOR

Uses the bitwise XOR (^) operator to manipulate the bit values.

   
mysql>
mysql>
mysql> SELECT 8 ^ 8, 8 ^ 10, 8 ^ 16;
+-------+--------+--------+
| 8 ^ 8 | 8 ^ 10 | 8 ^ 16 |
+-------+--------+--------+
|     0 |      2 |     24 |
+-------+--------+--------+
1 row in set (0.00 sec)

mysql>

   
    
    
  

Related examples in the same category