MySQL case when group by example

A mysql-like php switch case statement.

1. select xx field,
2. Case Field
3. when condition 1 then value 1
4. when condition 2 then value 2
5. else other value END alias
6. from table name;

Here is an example of group summation:

select sum(redpackmoney) as stota,ischeck 
from t_redpack
group 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_redpack
group by isCheck

In checkinfo, -1, 0, 1 are replaced with checkfalse, uncheck, checktrue (CASE WHEN performs string replacement processing)

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