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)
SELECT LEFT(字段2,2),COUNT(*) FROM TT GROUP BY LEFT(字段2,2)
SELECT LEFT(字段2,2),SUM(字段3) FROM table1 GROUP BY LEFT(字段2,2)
SELECT LEFT(字段2,2),SUM(字段3) FROM TT GROUP BY LEFT(字段2,2)
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)