title: MySQL: Select all fields start with given number and next character is letter?
body: <p>I have a table with random varchar number/letters as such:</p>
  
  <pre><code>1a
  101a
  101b
  101c
  11b
  14a
  14b
  14c
  14z
  108a
  108b
  </code></pre>
  
  <p>and I would like to <code>SELECT * FROM TABLE WHERE VAR = [SPECIFIC NUMBER]/FOLLOWING ANY LETTER</code>.</p>
  
  <p>For example <strong>I am using this wrong</strong> method where it selects everything starting with 1:</p>
  
  <pre><code>SELECT * 
  FROM  `table` 
  WHERE var LIKE  '1%'
  </code></pre>
  
  <p>which gives me all of the above example because all start with 1.
  I want this to select only: <code>1a</code></p>