title: MySQL SELECT substring? or regex?
body: <p>I have a column that stores a 9 digit number.  </p>
  
  <p>I'd like to select data where the number starts with 4 zeros - followed by a non-zero number as the 5th character :
  i.e. 000038652
  something like :<br>
  ....<br>
      WHERE SUBSTRING(num_column,0,4) = '[0-0]'<br>
  or :<br>
      WHERE num_column REGEXP  '^[0-9]{4}$'  </p>