MySQL Tutorial/Math Numeric Functions/Modulo
Modulo operation (%): Returns the remainder of N divided by M.
<source lang="sql">
mysql> mysql> select 5%2; +------+ | 5%2 | +------+ | 1 | +------+ 1 row in set (0.00 sec) mysql></source>
<source lang="sql">
mysql> mysql> select 5%2; +------+ | 5%2 | +------+ | 1 | +------+ 1 row in set (0.00 sec) mysql></source>