title: MySQL Remove first two characters of all fields
body: <p>I have some data that looks like this:</p>
  
  <pre><code>C:10
  R:200
  N/A
  E:3
  N/A
  N:77
  </code></pre>
  
  <p>I'm trying to remove the first two characters for each row, and skip the rows with <code>N/A</code> I've been trying to figure out how to do this with <code>SUBSTRING</code> but have had no luck.</p>
  
  <pre><code>UPDATE d1
  SET d1_val = SUBSTRING(d1_val, 1, LENGTH(d1_val)2)
  </code></pre>