title: SQL where 'does not contain Numerics', is it possible?
body: <p>I have a table full of rows, each row has a status and a sequence id (and a bunch of super secret stuff which isn't important here). The status is either a string indicating the current status of the record, or an id number indicating it is a child to a parent with that sequence number, who will contain the status of the tree. Basically our table contains Trees where the parents hold status information and all the children contain upward pointers. (It's pretty bad designed I know, but it is legacy and not worth changing quite yet.)</p>
  
  <p>First what I need is a list of all of the statuses for all of our families, and their sequence ids. So I would need something like</p>
  
  <pre><code>SELECT UNIQUE status, seq_id FROM top_secret_database.government_secrets_table 
  WHERE status &lt;does not contain numerics&gt; 
  </code></pre>
  
  <p>does anyone know a way to accomplish this in sql?</p>
  
  <p>I can do </p>
  
  <pre><code>SELECT UNIQUE status, seq_id FROM top_secret_database.government_secrets_table 
  WHERE status NOT IN (
      SELECT UNIQUE seq_id FROM top_secret_database.government_secrets_table
  )
  </code></pre>
  
  <p>But at this point I'm just curious if there is any way to get any regex like 'not numerics' in sql that anyone knows of because that would be useful done the line. Any suggestions?</p>