title: Column that starts with AST and ends in only number
body: <p>I suck at REGEX, but I need to pull all the records from a table column that stats with <code>AST</code>, and the rest only contains numbers after. I am assuming this can be done with just REGEX and not LIKE but I'm not sure.</p>
  
  <p>For instance <code>AST000001</code></p>
  
  <p>and not <code>AST99XXH011</code></p>
  
  <pre><code>SELECT * FROM table WHERE column LIKE 'AST%' AND column REGEXP '[0-9]$'
  </code></pre>