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)