# **%,MOD**

## **Operator Description**

The `%,MOD` operator is used for the remainder operation. Returns the remainder of the result N divided by M.

## **Grammar Structure**

```sql
SELECT N % M, N MOD M;
```

## **Example**

```text
mysql> select 12 mod 5;
+---------+
| 12 % 5 |
+---------+
| 2 |
+---------+
1 row in set (0.00 sec)
```

```text
create table t2(c1 int, c2 int);
insert into t2 values (-3, 2);
insert into t2 values (1, 2);

mysql> select c1 mod 2 from t2;
+---------+
| c1 % 2 |
+---------+
| -1 |
| 1 |
+---------+
2 rows in set (0.01 sec)

mysql> select c1 mod c2 from t2;
+-----------+
| c1 % c2 |
+-----------+
| -1 |
| 1 |
+-----------+
2 rows in set (0.01 sec)
```