title: getting syntax error in case statement in mysql query
body: <p>I am getting a syntax error in case statement in mysql.
  1064- you have an error in your sql statement.</p>
  
  <pre><code>insert into
  abc_table(release_date,title,detail,num)  
  select model1.release_date,model1.title,model1.detail,model1.num
  CASE 
  WHEN model1.num= 0 THEN 3
  WHEN model1.num= 1 THEN 1
  WHEN model1.num= 2 THEN 2
  END AS model1.num
  from def_table  model1
  </code></pre>
  
  <p>Is this syntax is correct in mysql</p>