字段1 字段2 字段3
1 ABC 10
2 ACB 20
3 ABD 30
4 ABF 40
5 ACF 50
6 ACH 60
求出 AB*的和=10+30+40
求出 AC*的和=20+50+60他们的值
1 ABC 10
2 ACB 20
3 ABD 30
4 ABF 40
5 ACF 50
6 ACH 60
求出 AB*的和=10+30+40
求出 AC*的和=20+50+60他们的值
mysql> select * from test;
+--------+--------+--------+
| field1 | field2 | field3 |
+--------+--------+--------+
| 1 | ABC | 10 |
| 2 | ACB | 20 |
| 3 | ABD | 30 |
| 4 | ABF | 40 |
| 5 | ACF | 50 |
| 6 | ACH | 60 |
+--------+--------+--------+
6 rows in set (0.00 sec)mysql> select * from(
-> select 'AB' as f,sum(if(field2 like 'AB%',field3,0)) as v from test
-> union all
-> select 'AC' as f,sum(if(field2 like 'AC%',field3,0)) as v from test
-> ) t;
+----+------+
| f | v |
+----+------+
| AB | 80 |
| AC | 130 |
+----+------+
2 rows in set (0.00 sec)