title: MySQL 5.5 Case incorrect syntax
body: <p>Hey I can't get this case statement to work, would someone mind telling what is wrong with the syntax is. </p>
  
  <pre><code>SELECT standards.standard_id, standards.title, standards.level,standards.credits, SUM(standards.credits), standards.assessment 
  
  CASE  WHEN standards.assessment = 1 THEN 'External' ELSE 'Internal' END CASE
  FROM standards JOIN courses_standards ON standards.standard_id = courses_standards.standard_id 
  WHERE courses_standards.course_id = 1
  </code></pre>
  
  <p>The exact error is: </p>
  
  <blockquote>
    <p>1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CASE WHEN standards.assessment = 1 THEN 'External' ELSE 'Internal' END CASE FR' at line 3</p>
  </blockquote>