title: Select a numbers only pattern from a text field in MySQL
body: <p>I have a column in my table that contains a text record of some large logging data.  These fields will have a 9 digit number (0-9) that starts with "3".   </p>
  
  <p>I simply want to <strong>select</strong> <em>only the pattern from this field</em>, not the whole field.  And to make things complicated, this pattern can be in a field <em>more than once</em>.</p>
  
  <p>I think the <code>REGEX</code> I need is <code>3{8}[0-9]</code> this?</p>
  
  <p>Is there a MySQL way only to do this?  I'd rather not have to write a php script to extract this data.</p>
  
  <p><strong>EDIT:  It seems this is not possible with REGEX - can it be done with any of the other MySQL String functions?</strong></p>