Truncate your answer to decimal places mysql

truncate your answer to decimal places mysql

SELECT TRUNCATE(135.375, 2);   -- Result: 135.37

SELECT TRUNCATE(COLUMN_NAME, X) FROM TABLE;
-- Truncate values in the COLUMN_NAME upto X decimal places