Mysql 取字段值逗号第一个数据的查询语句

复制代码代码如下:
select count（*） as lot from OA_sample_check where left（ecnNO, LOCATE（",",ecnNO）-1）="a1"