The modulo function returns the remainder of two numbers. : MOD « Math Numeric Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Math Numeric Functions
  3. MOD
mysql>
mysql>
mysql> SELECT MOD(14, 3) as Result;
+--------+
| Result |
+--------+
|      2 |
+--------+
1 row in set (0.00 sec)

mysql>








21.24.MOD
21.24.1.MOD(N,M), N % M, N MOD M: modulo operation. returns the remainder of N divided by M.
21.24.2.MOD(N,0) returns NULL.
21.24.3.The modulo function returns the remainder of two numbers.
21.24.4.(MOD(4, 0)) will return a null value