mysql trim leading zeros code example Example: mysql decimal remove trailing zeros SELECT TRIM(`column_name`)+0 FROM `table_name`;