mySQL trim leading zeros

UPDATE table SET column= TRIM(LEADING '0' FROM column) WHERE column LIKE '0%'