title: How to write a MYSQL CASE WHEN statement with multiple search conditions?
body: <p>I know languages like PHP has switch case control structure that supports multiple validations in a single case statement like,</p>
  
  <pre><code>Switch $x {
    case 1,2,3: 
        $a = 0;
         break;
    case 5,6: 
         $a = 1;
         break;
  }
  </code></pre>
  
  <p>Similarly can this be done in MYSQL? I tried below, which really didn't work though :(</p>
  
  <pre><code>CASE vc_shape
     WHEN ('02' OR '51') THEN SET dc_square_1 = dc_square_1 + dc_row_total;
     WHEN ('06' OR  '30' OR 83) THEN SET dc_square_2 = dc_square_2 + dc_row_total; 
     .....
     .....
    ELSE
        BEGIN
        END;
  END CASE; 
  </code></pre>
  
  <p>Any ideas how can I achieve this?</p>