Articles/SQL

MOD() in MySQL — How It Works

What the MySQL MOD() function does, with an example.

Published October 21, 2026

MOD() returns the remainder of dividing one number by another.

Key points

  • Part of standard SQL functions available in MySQL for working with query results

Example

SELECT MOD(10, 3);  -- 1
More SQL articles