MOD
Mod stands for Modulo. Calculates the remainder of a number divided by another number.
Syntax
MOD (expression1 , expression2) expression1 MOD expression2 expression1 `%` expression2
Arguments
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.
Return Type
A decimal if the input is decimal, otherwise integer.
Remarks
Returns NULL if the divisor is 0 or either of the arguments is a NULL.
Examples
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)