MySQL›Numeric Functions›MOD
←TRUNCATE

MODNumeric Functions

POWER→

Returns the remainder of n divided by m.

Syntax

MOD(n, m)

Example

Enter values below to update the example in real time.

employees→
employee_id→
-- 짝수 행만 조회
SELECT *
FROM employees
WHERE MOD(employee_id, 2) = 0;