mysql remove zeros from number 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`;