MySQL Mod Operator

In MySQL Mod operator also known as Modulo operation, returns the remainder of N divided by M.

MySQL MOD OPERATOR Syntax

To perform Modulo operation and get remainder, use the following syntax:

MOD( n, m );

OR

n MOD m;

OR

n % m;

Parameters:

n: The value that will be divided by m.

m: The value that will be divided into n.

MySQL DIV OPERATOR example

SELECT MOD(11, 2);

OR

SELECT 13 MOD 5;

Note:

In the above example, we are performing Modulo operation and getting remainder value.

You can use MySQL Command Line Client to perform Modulo operation and get remainder value. It will look like this: