I need to remove all leading 0's in a column

Your SQL contains errors. First, remove FROM, it is not using with UPDATE. Second, write correct SET to update column, not just select.

 

UPDATE `catalog_product_entity_varchar`
SET `value` = TRIM(LEADING '0' FROM `value`)
WHERE 1;