Mega Code Archive

 

Categories / MySQL Tutorial / Logic Operator

 

Logical AND(AND, &&)

Evaluates to 1 if all operands are non-zero and not NULL. Evaluates to 0 if one or more operands are 0. Otherwise NULL is returned. mysql> mysql> SELECT 1 && 1; +--------+ | 1 && 1 | +--------+ |      1 | +--------+ 1 row in set (0.00 sec) mysql> SELECT 1 && 0; +--------+ | 1 && 0 | +--------+ |      0 | +--------+ 1 row in set (0.00 sec) mysql>