Syntax:MOD(N,M), N % M, N MOD MModulo operation. Returns the remainder of N divided by M.
mysql> SELECT MOD(234, 10); -> 4mysql> SELECT 253 % 7; -> 1mysql> SELECT MOD(29,9); -> 2mysql> SELECT 29 MOD 9; -> 2