Syntax
MOD(N,M)
Purpose
The remainder function. The MOD(N,M), N % M, and N MOD M forms are equivalent.
MOD() also works with values that have a decimal part. It returns the exact remainder after the division.
If either N or M is NULL, the result is NULL. If M is 0, the result is also NULL.
Examples
obclient> SELECT MOD(29,19), 29 MOD 19, 29 % 19;
+------------+-----------+---------+
| MOD(29,19) | 29 MOD 19 | 29 % 19 |
+------------+-----------+---------+
| 10 | 10 | 10 |
+------------+-----------+---------+
1 row in set