# **AND,&&**

## **Operator Description**

`AND,&&` logical operators are used for *logical and* operations. If all operands are non-zero and not `NULL`, the result is `true`; if one or more operands are 0, the result is `false`; if one or more operands are non-zero and not `NULL`, the result is `NULL`.

## **Grammar Structure**

```sql
SELECT column_1 AND column_2 FROM table_name;
```

## **Example**

```text
mysql> select 1 and 1;
+-----------+
| 1 and 1 |
+-----------+
| true |
+-----------+
mysql> select 1 and 0;
+-----------+
| 1 and 0 |
+-----------+
| false |
+-----------+
mysql> select 1 and null;
+----------------+
| 1 and null |
+----------------+
| NULL |
+----------------+
mysql> select null and 0;
+----------------+
| null and 0 |
+----------------+
| false |
+----------------+
1 row in set (0.01 sec)
```

```text
create table t1 (a boolean,b bool);
insert into t1 values (0,1),(true,false),(true,1),(0,false),(NULL,NULL);
mysql> select a and b from t1;
+-----------+
| a and b |
+-----------+
| false |
| false |
| true |
| false |
| NULL |
+-----------+
5 rows in set (0.00 sec)
```