AND,&&

Description

Logical AND,&&. Evaluates to true if all operands are nonzero and not NULL, to false if one or more operands are 0, otherwise NULL is returned.

Syntax

  1. > SELECT column_1 AND column_2 FROM table_name;

Examples

  1. mysql> select 1 and 1;
  2. +---------+
  3. | 1 and 1 |
  4. +---------+
  5. | true    |
  6. +---------+
  7. mysql> select 1 and 0;
  8. +---------+
  9. | 1 and 0 |
  10. +---------+
  11. | false   |
  12. +---------+
  13. mysql> select 1 and null;
  14. +------------+
  15. | 1 and null |
  16. +------------+
  17. | NULL       |
  18. +------------+
  19. mysql> select null and 0;
  20. +------------+
  21. | null and 0 |
  22. +------------+
  23. | false      |
  24. +------------+
  25. 1 row in set (0.01 sec)
  1. create table t1 (a boolean,b bool);
  2. insert into t1 values (0,1),(true,false),(true,1),(0,false),(NULL,NULL);
  3. mysql> select a and b from t1;
  4. +---------+
  5. | a and b |
  6. +---------+
  7. | false   |
  8. | false   |
  9. | true    |
  10. | false   |
  11. | NULL    |
  12. +---------+
  13. 5 rows in set (0.00 sec)