How do I write this MySQL query?
You can use ORDER BY with LIMIT 1 for this:

SELECT t.*                           -- the columns you want
FROM table_name AS t
WHERE t.column_name &lt;= 95            -- your parameter
ORDER BY column_name DESC
LIMIT 1 ;