title: I need to remove all leading 0's in a column
body: <p>So this is the query I want to use. I think it's easier to just look at it and see where I am in the wrong:</p>
  
  <pre><code>UPDATE * FROM 'catalog_product_entity_varchar' 
  SET TRIM(LEADING '0' FROM 'value') 
  WHERE 'attribute_id' = '176';
  </code></pre>
  
  <p>So in my table there are a lot of rows with attribute_id = 176, and the column "value" has a lot of leading 0's. I want to remove all of the leading 0's from value when the attribute_id is 176.</p>
  
  <p>This is a bit beyond me, but it seems faster than trying to update any other way.</p>