title: using mysql regex_replace with a regular expression
body: <p>I am using regex_replace function found here
  <a href="http://techras.wordpress.com/2011/06/02/regex-replace-for-mysql/" rel="nofollow noreferrer">http://techras.wordpress.com/2011/06/02/regex-replace-for-mysql/</a></p>
  
  <p>This function works well in php but seem's not to like hash's. I am using this pattern </p>
  
  <pre><code>#^(0*)|([^\da-z])#i
  </code></pre>
  
  <p>in a regular expression found here
  <a href="https://stackoverflow.com/questions/24801900/how-can-i-remove-all-non-alpha-numeric-characters-and-leading-zeros">How can I remove all non alpha numeric characters and leading zeros</a></p>
  
  <p>How can i make this work in mysql either my changing the mysql function or adjusting the expression</p>