title: MySQL REGEXP No Whitespaces No Numbers
body: <p>I'm trying to return only those rows which colA and colB do not contain a number or a whitespace</p>
  
  <p>Here is my code so far. </p>
  
  <pre><code>SELECT * FROM table_name WHERE colA REGEXP '[^0-9^\W]' AND colB REGEXP '[^0-9^\W]'
  </code></pre>
  
  <p>given the dataset</p>
  
  <pre><code>   colA        colB
  ---------- ----------
       test |  testB
        33  |  text    &lt;- this is not returned
       blah |  0123A   &lt;- this is returned
  </code></pre>
  
  <p>I am assuming my issue is with my regexp... any help please?</p>