title: Using ASC/DESC within an ORDER BY CASE()
body: <p>What I need to do is order them from Classroom, Laboratories, Lecture Halls followed by Auditoriums. What I then need to do is to arrange them by their ID. So for the classrooms, I start from 1 and ascend accordingly.</p>
  
  <p>The only fields I utilize are the roomID and the type column. (Should change type seeing as how it is an SQL function huh?)</p>
  
  <pre><code>SELECT * 
    FROM `rooms` 
  ORDER BY CASE WHEN `type` = 'Classroom'
      THEN 1 
    WHEN `type` = 'Computer laboratory'
      THEN 2 
    WHEN `type` = 'Lecture Hall'
      THEN 3 
    WHEN `type` = 'Auditorium'
      THEN 4 
    END
  </code></pre>
  
  <p>It seems simple enough, but I can't get it to work. So, any help would be greatly appreciated, especially since this is probable a stupid question.</p>