how to remove all zeros from a number in mysql code example

Example: eliminate zero from integer mysql

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