Question

what is the difference between || and ! operator in MYSQL? explain with example.

​

Answer 1

Explanation:

OR operator is also used to combine multiple conditions with WHERE clause. The only difference between AND and OR is their behaviour. When we use AND to combine two or more than two conditions, records satisfying all the specified conditions will be there in the result.