title: Update Statement with Case in MYSQL
body: <p>I have this issue and I have investigated more than five house but find nothing :( . I have table called support.</p>
  
  <pre><code>UPDATE support s SET    s.Survey_Status = 0
  CASE 
  WHEN s.Survey_Status = 0 Then 1
  WHEN s.Survey_Status = 1 Then 2 
  End 
  Where last_response &lt; ADDDATE(CURDATE(), INTERVAL 1 DAY) 
  and support_waiting ="n" ;
  </code></pre>
  
  <p>I need to update the support table and set the survey_status =1 except the fifth row in the table will be =2 . For example, if I have survey_ status from 1 to 10 = 1 then the fifth will =2 . any idea please  ??
  By the way, I am working with mysql Heidi .</p>
  
  <p>Thanks in Advance </p>