Mysql 取字段值逗号第一个数据的查询语句
程序员文章站
2024-02-24 18:46:52
复制代码 代码如下: select count(*) as lot from oa_sample_check where left(ecnno, locate(',',ec...
复制代码 代码如下:
select count(*) as lot from oa_sample_check where left(ecnno, locate(',',ecnno)-1)='a1'