title: MYSQL CASE WHEN UPDATE Query
body: <p>This is my table.</p>
  
  <p><img src="https://i.imgur.com/ElmiW.png" alt=""></p>
  
  <p>What I need to do is create a CASE WHEN UPDATE Query to update</p>
  
  <ul>
  <li><p>CurrentCredit +1 if 1-15</p></li>
  <li><p>CurrentCredit +2 if 16-30</p></li>
  <li><p>CurrentCredit x.10 and round up if >=31</p></li>
  </ul>