如何编写具有多个搜索条件的MYSQL CASE WHEN语句? [英] How to write a MYSQL CASE WHEN statement with multiple search conditions?

问题描述

我知道PHP之类的语言具有切换用例控制结构，该结构支持在单个case语句中进行多种验证，例如

I know languages like PHP has switch case control structure that supports multiple validations in a single case statement like,

Switch $x {
  case 1,2,3: 
      $a = 0;
       break;
  case 5,6: 
       $a = 1;
       break;
}

同样可以在MYSQL中完成吗?我在下面尝试了，但实际上没有用:(

Similarly can this be done in MYSQL? I tried below, which really didn't work though :(

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; 

任何想法如何实现?

推荐答案

对CASE语句使用其他格式:

CASE 
   WHEN vc_shape IN ('02', '51') THEN SET dc_square_1 = dc_square_1 + dc_row_total;
   WHEN vc_shape IN ('06', '30', '83') THEN SET dc_square_2 = dc_square_2 + dc_row_total; 
   .....
   .....
  ELSE
      BEGIN
      END;
END CASE; 

这篇关于如何编写具有多个搜索条件的MYSQL CASE WHEN语句?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！