MYSQL
SELECT left(city,LOCATE(‘ ‘,city)),count(*) FROM `lj_customer` WHERE 1=1 group by left(city,LOCATE(‘ ‘,city))
SQL
select a,left(a,charindex( ‘ ‘,a)) FROM test
SELECT left(city,LOCATE(‘ ‘,city)),count(*) FROM `lj_customer` WHERE 1=1 group by left(city,LOCATE(‘ ‘,city))
原文：http://www.cnblogs.com/zhangzhijian/p/7100999.html