MySQL NULLIF Operator

The MySQL NULLIF operator is a control flow function that accepts two arguments. If argument 1 is equal to argument 2, then NULL is returned. Otherwise, argument 1 returned. The syntax behind this NULLIF is as follows: SELECT NULLIF(exp1, exp2) This NULLIF function returns NULL if exp1 = exp2. Otherwise, it returns the expression 1 … Read more