The MOD() function returns the remainder of "Number" divided by "Divider".
Synonymous can also be written "Number % Divider" or "Number MOD Divider".
If the ERROR_FOR_DIVISION_BY_ZERO in the system variable SQL_MODE is active, a "Divider" with the value 0 will generate an error, otherwise NULL will be returned.
If any of the arguments is NULL, the function returns NULL.
The integer part of a division can be get with "Number DIV Divider".