title: Mysql custom order by and alphabetical order by:
body: <p>I am using the following query:</p>
  
  <pre><code>$query = "SELECT * FROM `$table[$a]` ORDER BY FIELD(typeof,'pdf','swf','img','web')";
  </code></pre>
  
  <p>to select and customly order my mysql query, it works great except there are multiple files within each typeof and I now want to order them alphabetically yet retaining their typeof order. Make sense?</p>