Articles/SQL

FLOOR() in MySQL — How It Works

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

Published October 21, 2026

FLOOR() rounds a number down to the nearest integer.

Key points

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

Example

SELECT FLOOR(19.9);  -- 19
More SQL articles