title: Selecting first 4 numbers from a string MySQL
body: <p>If I have strings like this:</p>
  
  <pre><code>CC123484556
  CC492014512
  BUXT122256690
  </code></pre>
  
  <p>How can I manipulate code like this in MySQL to pull the first 4 values that are numbers ?  There are various # of letters before numbers in other rows but the most important thing are the first 4 numbers that show up.</p>
  
  <pre><code>SELECT LEFT(alloy , 4) FROM tbl 
  </code></pre>
  
  <p>So the desired result would be:</p>
  
  <pre><code>1234
  4920
  1222
  </code></pre>