title: Mysql query to select a column with only alphabetical characters
body: <p>I need to display records from mysql database where a particular column has only alphabets.</p>
  
  <p>eg, </p>
  
  <p>Table Name: data</p>
  
  <pre><code> column
   abcde
   12345
   xyz
   123
  </code></pre>
  
  <p>so the output should be abcde and xyz only.
  So far i tried using pattern match but no luck</p>
  
  <p>here is what is use yet
     <code>SELECT * FROM listing WHERE Zip LIKE '[^a-zA-Z]'</code></p>