title: SQL Select Statement(REGEXP) to find special characters and numbers in an alpha only field
body: <p>I am using mySQL to query a field which would be <code>LastName</code>. I am looking for any errors in the field such as any special characters or numbers. I am not terribly familiar with SQL so this has been a challenge so far. I have written simple statements with <code>REGEXP</code> but I have run into some issues the <code>REGEXP</code> i was using was: </p>
  
  <pre><code>SELECT LastName FROM `DB`.`PLANNAME` where LastName REGEXP '^([0-9])'
  </code></pre>
  
  <p>now this turned up results where numbers were the first character in the string and i realized that if anything was in the middle of the string that started with a letter this would not pick it out. </p>
  
  <p>To be clear i just need to find the errors not write a code to clean them out.</p>
  
  <p>Any help would be greatly appreciated </p>
  
  <p>Thanks </p>
  
  <p>Pete </p>