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

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

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

标签：back   amp   count   har   数据   ons   字段   ott   one