title: Rails SQL regular expression
body: <p>I'm trying to search for the maximum number in the series A0001, A0002, A1234, A2351, etc...  The problem is that the list I'm searching in also has strings such as AG108939, E092357, AL399, 22-30597, etc...  </p>
  
  <p>So basically, I want the Highest A#### value in my database.  I was using the following query:</p>
  
  <pre><code>@max_draw = Drawing.where("drawing_number LIKE ?", "A%")
  </code></pre>
  
  <p>Which was working until numbers such as AG309 started getting in the way because it starts with an A, but has a different format than what I'm looking for.</p>
  
  <p>I'm assuming this should be pretty straight forward with regular expressions, but I'm new to this and don't know how to correctly write this query with a regular expression.  Here are some things I've tried that just return nil:</p>
  
  <pre><code> @max_draw = Drawing.where("drawing_number LIKE ?", /A\d+/)
   @max_draw = Drawing.where("drawing_number LIKE ?", "/A\d+/")
   @max_draw = Drawing.where("drawing_number LIKE ?", "A[0-9]%")
  </code></pre>