SQL 截取字段空格之前的数据

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))

【推广】免费学中医，健康全家人

原文地址：https://www.cnblogs.com/zhangzhijian/p/7100999.html