Home >Database >Mysql Tutorial >Mysql 取字段值逗号第一个数据的查询语句_MySQL
Mysql 取字段值逗号第一个数据的查询语句_MySQL
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-01 13:25:361068browse
bitsCN.com
select count(*) as lot from OA_sample_check where left(ecnNO, LOCATE(',',ecnNO)-1)='a1'
bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MYSQL主从不同步延迟原理分析及解决方案_MySQLNext article：mysql高效导数据的方法讲解_MySQL