title: MySQL ORDER BY [custom SET field value]
body: <p>I hope there's a simple solution for this:</p>
  
  <p>I have a table where each row has it's own status (<code>SET</code> type field). Statuses can be:</p>
  
  <ul>
  <li>offline</li>
  <li>available</li>
  <li>busy</li>
  <li>distance</li>
  </ul>
  
  <p>I'd like to order as follows</p>
  
  <ul>
  <li>available</li>
  <li>busy</li>
  <li>distance</li>
  <li>offline</li>
  </ul>
  
  <p>I thought a simple</p>
  
  <pre><code>ORDER BY `status` ASC
  </code></pre>
  
  <p>will do the trick (alphabetical order) but it gives me the following:</p>
  
  <ul>
  <li>offline</li>
  <li>available</li>
  <li>busy</li>
  <li>distance</li>
  </ul>
  
  <p>How can is sort out this in the most simple way?</p>
  
  <p>Thanks in advance,</p>
  
  <p>fabrik</p>