Example
Return the largest integer value that is less than or equal to 25.75:
SELECT FLOOR(25.75);
Definition and Usage
The FLOOR() function returns the largest integer value that is smaller than or equal to a number.
Note: Also look at the ROUND(), CEIL(), CEILING(), TRUNCATE(), and DIV functions. Continue reading MySQL FLOOR Function