How to use XOR operator in sql?

Answer 1

XOR means eXclusive OR. It returns true only if only one of the statements is true and the other one is false:
0 xor 0 -> 0
0 xor 1 -> 1
1 xor 0 -> 1
1 xor 1 -> 0

Answer 2

It's when you want that only one value on two is True and otherwise it's simply False. You will find more info here : https://dev.mysql.com/doc/refman/5.7/en/logical-operators.html

Answer 3

@Jignesh : What you said is NOR and not XOR

Answer 4

Thank you both ☺