mysql round to 2 decimal half up code example Example: round one decimal place mysql SELECT ROUND(20.555, 1); -- 20.5 SELECT ROUND(20.5, 0); -- 21