MOD

Get the remainder of division with MOD.

MOD(x, y) returns the remainder of x divided by y. The % operator does the same.

SELECT MOD(10, 3) AS kalan;

The remainder of 10 divided by 3 is 1.

The expression MOD(10, 3) AS kalan is evaluated and returned.

MOD — details

To check even or odd use MOD(n, 2) = 0 for even. Modulus is used in cyclic grouping operations.

Select from products those whose id is even (using MOD).

Show example solution

SELECT name
FROM products
WHERE MOD(id, 2) = 0