mysql trim trailing zeros 0 from decimal code example

Example 1: eliminate zero from integer mysql

REPLACE('0349010330', '0', '');

Example 2: mysql decimal remove trailing zeros

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