title: MySQL order by mixed ASC/DESC in the same column
body: <p>I am trying to sort product bin locations from a database by both ASC and DESC order in the same column, to allow a warehouse picker to weave through the warehouse isles to pick product.  In other words, when a picker gets a batch of orders to pick from the warehouse, the system needs to start them at the front of isle 1, then order picks going down the isle to the end.  Then it would jump them over to the end of isle 2 (instead of to the beginning), and they would work their way toward the front of isle 2, then start at the front of isle 3 and so on.  </p>
  
  <p>The bin locations are in the format: ISLE - BAY - SHELF - SLOT/BIN
  Here is an example data table of bin locations to pick:</p>
  
  <ul>
  <li>1-0-A-01</li>
  <li>1-1-D-06</li>
  <li>1-2-E-10</li>
  <li>1-2-E-11</li>
  <li>1-10-A-01</li>
  <li>2-1-D-02</li>
  <li>2-1-C-12</li>
  <li>2-5-F-01</li>
  <li>3-5-A-12</li>
  <li>3-6-D-01</li>
  <li>4-5-A-02</li>
  <li>4-5-A-03</li>
  <li>4-5-B-10</li>
  </ul>
  
  <p>I need to do a SQL query and pull the locations and order them like this:</p>
  
  <ul>
  <li>1-0-A-01</li>
  <li>1-1-D-06</li>
  <li>1-2-E-10</li>
  <li>1-2-E-11</li>
  <li>1-10-A-01</li>
  <li>2-5-F-01</li>
  <li>2-1-D-02</li>
  <li>2-1-C-12</li>
  <li>3-5-A-12</li>
  <li>3-6-D-01</li>
  <li>4-5-B-10</li>
  <li>4-5-A-03</li>
  <li>4-5-A-02</li>
  </ul>
  
  <p>Is it possible to do this with just a SQL query?</p>