title: ORDER BY numeric and characters
body: <p>I want to sort the following data items in the order they are presented below:</p>
  <pre><code>ZZZ-AA1
  ZZZ-AA2
  ZZZ-AA3
  ZZZ-AA11
  ZZZ-AA12
  ZZZ-AAA1
  ZZZ-AB1
  ZZZ-AB2
  ZZZ-BB1
  ZZZ-BB12
  ZZZ-CA1
  </code></pre>
  <p>Any tricks to make it sort more properly?</p>
  <p>Thanks!</p>
  <p>Queries that I have tried:</p>
  <pre><code>SELECT bay FROM table GROUP BY bay ORDER BY SUBSTR(bay FROM 1 FOR 6), CAST(SUBSTR(bay FROM 6) AS UNSIGNED)
  SELECT bay FROM table GROUP BY bay ORDER BY LENGTH(bay), bay
  </code></pre>