title: SQL match on letter and number arrangement
body: <p>Is it possible to write an SQL statement which finds all rows which match a specific arrangement of letters/numbers?</p>
  
  <p>i.e. <code>SELECT myCol FROM myTable WHERE myCol='&lt;letter&gt;&lt;letter&gt;&lt;number&gt;'</code></p>
  
  <p>Should return 12X and 34Y but not 123X or 34YY</p>
  
  <p>I am using MySQL.</p>