Mysql case when group by instance details, mysqlcase

Mysql case when group by instance details, mysqlcase

Similar to the php switch case statement in mysql.

1. Select xx field,
2. Case Field
3. When condition 1 then value 1
4. When condition 2 then value 2
5. Other else value END alias
6. From table name;

The following is an example of group summation:

Select sum (redpackmoney) as stota, ischeck from t_redpackgroup by isCheck

Use case when:

Select sum (redpackmoney) as stota, (CASE isCheck WHEN '1' then' checktrue 'when '0' THEN 'uncheck' when'-1 'then' checkfalse 'else 'unknow' END) as checkinfo from t_redpackgroup by isCheck

In checkinfo, replace-1, 0, and 1 with checkfalse, uncheck, and checktrue (case when for string replacement)

The above is a simple example of the case when statement in mysql.