CODE EXAMPLE FOR SQL

mysql decimal remove trailing zeros

SELECT TRIM(`column_name`)+0 FROM `table_name`;