Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
Aggregate function. Mod
stands for Modulo. Calculates the remainder of a number divided by another number.
MOD (expression1 , expression2)
expression1 MOD expression2
expression1 `%` expression2
expression1, expression2 : any numerical expression. This could be a column name, the result of another function, or a math operation.
expression1 : dividend. A value that will be divided by expression2.
expression2 : divisor.
A decimal if the input is decimal, otherwise integer.
Returns NULL if the divisor is 0 or either of the arguments is a NULL.
The following queries return the remainder.
SELECT MOD (84,5);
****
+------------------------------+
| mod (84,5) |
+------------------------------+
| 4 |
+------------------------------+
1 row in set (899 ms)
SELECT 12 MOD 5;
****
+------------------------------+
| 12 MOD 5 |
+------------------------------+
| 2 |
+------------------------------+
1 row in set (346 ms)
The following query returns NULL
as the divisor is 0.
SELECT 25 % 0;
****
+------------------------------+
| 25 % 0 |
+------------------------------+
| NULL |
+------------------------------+
1 row in set (341 ms)