Question

what is the substitute of or operator in mysql​

Answer 1

MySQL IS operator tests a value against a Boolean value. A boolean value can be TRUE, FALSE, or UNKNOWN. In the following MySQL statement, it is checked whether 5 is TRUE, 0 is TRUE and NULL is UNKNOWN using IS operator. For the first and third case it returns 1, for the second case, it returns 0.